11,093 Topics
 | |
| | Hi, I have a variable @FranchiseId declared in my stored procedure If I try the following select command, will it work???? SELECT @FranciseId=(select FranchiseName FROM franchise WHERE username=@username),username FROM MyTable I hope you Understood My problem!! |
| | HI, I'm new to VB6 programming and i need some help of anyone to please help with my problem. I want to know what do I need to do or know before to create a code that connect VB6 to my SQL. and if you desire please give a sample …  |
| | <?php ob_start(); include("sys.php"); session_start();//when nid use session nid put tis ?> <html> <title></title><head></head> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblSample'); var lastRow = tbl.rows.length; // if there's no header row in the table, then iteration = lastRow + 1 var iteration = lastRow; var row = tbl.insertRow(lastRow); var …  |
| | Hello, i hav no idea abt MySQL, but i have a program with access database. Is it possible to convert it to MySQL database?? Any HELP please.. and i wanted to know also that all the code also will need to be change?? any way how should i start..?? thanks |
 | hello, i'm very dull at js, so i hope you guys can help me. ok, i have create a prompt box that will ask user to enter a password, and this prompt box will take user to secured page. [CODE] <script type="text/javascript"> function show_prompt() { var name=prompt("Please enter your password","Fill …  |
 | Hi there I'd like to know if it's possible to combine an update and insert query into one query. What I'd like to do is insert new data into one table and update a colum in another table at the same time. For example, there are 3 different baskets (puppy … |
| | Hi , i am vipin facing a problem in mysql table i hava two table, primary key of one table is used as a foreign key of another table. but when i inserting some values in first table it gives [B][COLOR="Red"]error:Cannot add or update a child row: a foreign key … |
| | I am trying to store millions of records with address, city, state, zip, etc. I originally had one table with 17 different fields with the primary key being id. However, I soon realized after inserting almost a million, the website began to lag and was slow. What is the best … |
| | hello!!!...i want to start program a to store video record to database using vb2008 and mysql..but i dont know how to start since i still new to this whole thing about programming..can someone help me??? |
| | hello, need help from you guys. ok, i have create a prompt box that will ask user to enter a password, and this prompt box will take user to secured page. [CODE] <script type="text/javascript"> function show_prompt() { var name=prompt("Please enter your password","Fill Here"); if (name!=null && name!="") { location.href="index.php"; } … |
 | I have code like this, it shows data when tehre is data but if there is no data i want to say "no records" where am i going wrong? [CODE]<?php require_once('db_conf.php'); $sql = "SELECT * FROM tbl_holidayspecials WHERE fld_country = '$countryname' AND fld_state = '$statename' AND fld_city = '$cityname'"; $result … |
| | So.. I dont know why i cant find a specific tutorial / tip on this, so i'll ask you guys. I'm trying to get $date to get the current date and insert it as the query executes. [CODE]$result=mysql_query("INSERT INTO articles (`loginid`,`title`,`author`,`body`,`date`,`category`) VALUES ('$loginid','$title','$author','$body','$date','$category')") [/CODE] this is my Database. [CODE]CREATE TABLE … |
| | I am trying to update a mysql entry. Getting this error; [CODE]Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('loginid='15',title='Test',author='Sorcher',body=' Yeah just testing this aga' at line 1[/CODE] [CODE]if ($_GET['edit']){ $getedit … |
| | Good day all: Is there a mechanism through which I can have a button on my html form which on click calls a script that converts the form (or the html page) into a pdf file and inserts the file into mysql table with a specified name originating from the …  |
| | It wont work, the script might be messed up, please help / give a hint, i'll rep any help. [CODE]<?php session_start(); error_reporting(E_ALL); //////POST STATEMENTS/////////// $loginid = $_POST['loginid']; $title = $_POST['title']; $author = $_POST['author']; $body = $_POST['body']; $category = $_POST['category']; $dbLink = new mysqli('xxxxx.xxxxxx.com', 'xxxxxxx', 'xxxxxxx', 'xxxxxxx'); if(mysqli_connect_errno()) { die("MySQL connection … |
| | getting the problem ~ mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /studhome/1/0803087/public_html/RSS.php on line 14 trying to create a RSS feed no idea what is wrong, so can anyone help [CODE] <? // Connect to database DEFINE ('DB_USER', '******'); DEFINE ('DB_PASSWORD', '********'); DEFINE ('DB_HOST', '*****'); DEFINE … |
| | I get this error message: Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'testing this thing again' at line 2 NOTE: the 'testing this thing again' is $body This is my … |
| | I get the error #1005 - Can't create table 'db1.#sql-9e8_2c1' (errno: 150) (<a href="server_engines.php?engine=InnoDB&page=Status&token=3947cba14f7c39305d6f460b76698c5e">Details...</a>) I have 2 tables that I want to connect as a 1-1 relationship. table1:[U] a ,b[/U] ,c ,d table2: [U]a ,b[/U] the plan is that table2 will hold the keys of some of the records that … |
| | Hi, I am fetching date from the database which is submitted by user while form filling. The date came from database 2011-11-15. What i want to do,show date in below format. 2011-dec-15 or dec 15 2011 need help?? |
| | Please I need help, I don't know what I'm doing wrong here, [CODE] $query=( "UPDATE $tblname SET totwrong =".$wrongAnswers."', SET Test_score ='".$percentage."' WHERE UserName = '".$UserName."'"); [/CODE] It does not update the table, please please |
| | Does anyone know how I would go about storing something from my database into a variable to use elsewhere on my PHP code? |
| | Hi, I am fetching current date from mysql database by using curdate() function. 16-06-2011 what i want to do.. 16-june-2011 how it is possible in mysql Need help?????? |
| | Hi, I'm building out a social network system, and when trying to pull user info for a user's friends, I'm stumbling into a problem with the query. The issue is I'm trying to keep the lookup table from listing redundant entries. For instance, [CODE]FRIENDS TABLE ------------- uid | fid ------------- … |
| | Hi, I have 3 feilds in my invoice processing Table. [LIST=1] [*]Submet [*]Return [*]Resubmitted [/LIST] Now I am using this query [CODE=mysql]SELECT `SRNo` , `VenName` , `Submet` , TO_DAYS( NOW( ) ) - TO_DAYS( `Submet` ) AS Days FROM `invmain` WHERE `Status` = 'SENT TO PAYABLE' AND `Submet` != '0000-00-00' … |
| | Hello, I am building a stock market website and i want to show all commodities prices rise fall even charts later .first of i want to know whether it is possible or not.If yes please guide me through.Please help any kind of help appreciated |
| | Hey, the data in my DB isn't going to be in english, and I'm wondering if I should name the tables and the fields not in english as well, or there might be problems later when using the names in PHP or SQL code? any one had experience with that? |
| | table: hometeam awayteam homepoints awaypoints leeds man u 3 0 leeds man u 3 0 man u leeds 0 3 i want to calculate how many points each team has. with the above data leeds should have 9 and man u 0. i have come up wth the following sql … |
| | Ok so let me start off by saying I am not a NOOB. There... So i need help trying to figure out an export of just my 2 colums from a table. Got it done. Now i need to make sure that I only export from a date range and … |
| | Hello, I have a form from which I post some data into 3 tables: when I click on the submit button I don't get any error message from mysql_error(); but when I look to my 3 tables I see no one of them has received the data I just posted … |
| | I have an issue with an insert statement not producing what I think it should produce... Here are the relevant parts of the code: [CODE] $free_pos[0][0] = $free_pos[1][0] = $left_top = $row[0];// value is 10000002 $free_pos[0][1] = $free_pos[1][1] = $left_step = $row[1];// value is 1 $free_pos[2][0] = $free_pos[3][0] = $right_top … |
 | Hi there. Thinking about creating a membership registration-enabled website, that will store people names and some info about them, after they register, but what i can't begin to make is a PHP code that whenever, a user searchs ( In a search box ) a name of another user, that … |
| | I have two tables: CDDemographics and CBTechProviderData. Both have 200,000+ rows. A common column between these tables is CensusBlockID, of which the first 5 integers are the fips code - in this case I am defining that code as 55001. I am trying to sum the population of CensusBlockIDs where … |
| | Morning,afternoon,evening and av a great night to all, solution needed plaese. secnario. players eneter log on screen and enter name ,password, (id is index on base) then go to check_logon.php if happy end up at logon_success.php this run ok :) am now trying to display players id number on logon_success.php. … |
| | Hi, mysql_query() expects parameter 1 to be string, object given in C:\xampp\htdocs\livesearch\livesearch\ajax-search.php on line 18 need help [CODE]<?php include_once ('database_connection.php'); if(isset($_GET['keyword'])){ $keyword = trim($_GET['keyword']) ; $keyword = mysqli_real_escape_string($dbc, $keyword); $query = "SELECT * FROM register WHERE subject LIKE '%$keyword%'"; echo "SELECT * FROM register WHERE subject LIKE '%$keyword%' "; //echo … |
| | Hello to everyone. I have an old flat database with a couple of hundred entries that I want to convert to a relational design. It was a user database for simple login and some preferences. I would like to know if there is a simple way to convert from one … |
| | hey there, I am doing testing to my site and i need to make over 60 rows to check paging. Is there any possible way to just copy rows over and over again? Thank you, |
| | Hi all, I have a table with multiple apps listed on it. The table is auto populated with the all available apps. The admin then has a options to assign user permissions e.g. user, admin or none. I have attached a pic of my table. I wanted to know how … |
| | HI there.. I've spend almost a day looking for a script for image upload but unfortunately, i see none. so, I consider writing a thread here at daniweb so the advance programmer there will help me with my problem. Please help me in creating a script that will enable the … |
 | |
| | hi guys, quick question. i have 2 tables. Client Table: ClientID INT PK AI, ClientName VarChar Folders table: FolderID INT PK AI, FolderName VarChar, client_ClientID INT The issue i have is that i have created this virtual folder appliaction in the site and have created it now where when they … |
| | I have used the delete query $sql="DELETE FROM table_name WHERE id='$ids'"; but the problem isthat it deletes the record but the record does not disappears from the page. It dissappears after refreshing the code. I have used the meta tag for page refresh but itis not working. Can any one … |
| | hi, i opened two mysql sessions(A,B) and set the autocommit variable to 0 for both the sessions. by giving "set autocommit=0" then in session A i added a row to my table by calling a stored procedure and i tried doing the same in session B also.. but in session … |
| | Anyone want to help me with this SQL-code? [url]http://pastebin.com/VWnJmM34[/url] I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it? |
| | I'm a beginner on MySQL. I tried to run this statement [CODE]SELECT* FROM address WHERE email=a@abc.com[/CODE] but it shown an error message. What's wrong? |
| | can someone help me to write a query that will sum the information across the row and down the column (sum) in ms access table a b sum 1 10 11 2 20 22 total_all I tried the following select a,b, sum as (a+b) from table1 the error i get … |
 | Good day! This is the code I've done in saving and retrieving an image to and from a database...I have encountered an error in retrieving the image.....how can i solve this? can u help me..thanks...hope you reply soon... Imports System.Data Imports System.IO Imports MySql.Data.MySqlClient Public Class frmMain Dim cnString As … |
| | Hello all, I'm I am very new to using MySQL databases and came across an error that I need help with. I'm trying to make a simple Connection file in php to connect to one of my databases and it keeps giving me this error:"Warning: mysql_connect() [function.mysql-connect]: Access denied for … |
| | Hi all... I need your help, there must be something I am not seeing here when trying to update a table of information in a database. Here is the code I am currently using. In my program I have this call... [CODE] if (($_POST['changeAddress'] != "") || ($_POST['changeAddress'] != null)) …  |
| | I have recieved this, Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\...register.php on line 16 I dont understand to be honest what this mean as i am new to php and mysql. What do i need to do to fix this problem? Below is my php. … |
| | Hi, I have a problem duplicate entry in same time. I am getting some parameters in other gateway (some websites) and stored in Database. I trim all parameters. Before i store in db, i check db whether that record already exist or not. Other Gateway website which they send three …  |
The End.