Forum Moderators: coopster

Message Too Old, No Replies

still having problems.

         

Flolondon

10:54 pm on Mar 22, 2006 (gmt 0)

10+ Year Member



still having problems with this comment

MySQL 3.23,

Could Not Insert Record Into Database: 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 ')' at line 2

still confused..

Steerpike

1:09 am on Mar 23, 2006 (gmt 0)

10+ Year Member




Flo can you echo your sql statement before you get a result and post the information?

Your code will look something like this at the moment:

$sql = "this is where your sql statement is";

$rs = mysql_query($sql) or die(mysql_error());

Make it read:
$sql = "this is where your sql statement is";
echo $sql;
$rs = mysql_query($sql) or die(mysql_error());

and post what gets sent to the screen.

Cheers,
Steerpike

Habtom

8:33 am on Mar 23, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



This happens when you have something wrong with your SQL statement. What does your SQL statement look like?

Tell us your query please.

Habtom