|
-
Jun 18th, 2004, 08:16 PM
#1
Thread Starter
Lively Member
PHP / SQL statement *RESOLVED*
Code:
if( !mysql_db_query($sDB, "INSERT $sTableName VALUES (
'$sUsername', 0,
'$sPassword', 1,
'$sE_Mail', 2,
'$sAge', 3,
'$sName', 4,
'$sCountry', 5,
'$sSex', 6,
'$sSecret_Question', 7,
'$sSecret_Answer', 8,
'$sState', 9,
'$iPID', 10
)"))
{
echo "Error # :";
echo mysql_errno();
echo "<br>";
echo mysql_error();
}
prints out:
Error # :1136
Column count doesn't match value count at row 1
There are 11 columns and 11 values being assigned to the columns...so what could be causing the mismatch error?!
Last edited by Balron; Jun 19th, 2004 at 12:03 PM.
-
Jun 19th, 2004, 04:23 AM
#2
You're assigning 22 values. Re-read the syntax of INSERT statements.
All the buzzt
 CornedBee
"Writing specifications is like writing a novel. Writing code is like writing poetry."
- Anonymous, published by Raymond Chen
Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
-
Jun 19th, 2004, 12:03 PM
#3
Thread Starter
Lively Member
Originally posted by CornedBee
You're assigning 22 values. Re-read the syntax of INSERT statements.
I'm an idiot, thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|