mysql_query INSERT

[Unholy Prayer]

My database insertion code isn't working and I can't figure out why.  This is the code:

   mysql_query("INSERT INTO vbb_members(username,password,email,reg_date,mem_no,perm) values('$username', '$password', '$email', '$reg_date', '$mem_no', '$perm')") or die("Error: ".mysql_error());

[cmgmyr]

put a space after vbb_members and values ... it shouldn't really matter but try anyways, is it giving you an error, or just not inserting?

[Unholy Prayer]

It's displaying an error: 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 ''[email protected]''' at line 1  even after i put spaces in the places you said.

[cmgmyr]

o, try this:

\"$email\"

 

instead of

'$email'

[Unholy Prayer]

Now it's saying 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 ''Test' at line 1

[cmgmyr]

try:

mysql_query("INSERT INTO vbb_members (username,password,email,reg_date,mem_no,perm) values (\"$username\", \"$password\", \"$email\", \"$reg_date\", \"$mem_no\", \"$perm\")") or die("Error: ".mysql_error());

[kenrbnsn]

Change you code to:

<?php
$q = "INSERT INTO vbb_members(username,password,email,reg_date,mem_no,perm)
                      values('$username', '$password', '$email', '$reg_date', '$mem_no', '$perm');
$rs = mysql_query($q) or die ("Error in query:<pre>$q</pre><br>".mysql_error());
?>

 

This will display what the generated query looks like. If you don't see the error in the query, post it here.

 

Ken

[MadTechie]

Correction kenrbnsn missed a "

<?php
$q = "INSERT INTO vbb_members(username,password,email,reg_date,mem_no,perm)
                      values('$username', '$password', '$email', '$reg_date', '$mem_no', '$perm')";
$rs = mysql_query($q) or die ("Error in query:<pre>$q</pre><br>".mysql_error());
?>