[Resolved] Can't update MySQL table

[Jon12345]

I have a Form page edit.php that when I update some of the form fields and submit, it then goes to editsent.php.

editsent.php is below:

<?
include('dbconnect.inc');
mysql_query("UPDATE products SET Product='$Product', MetaTitle='$MetaTitle', CategoryID='$CategoryID', Data='$Data', WHERE ProductID='$ProductID'");
mysql_close();

header("Location: admin.php"); 
?>

But this is not updating the MySQL table.

Any ideas why?

Thanks,

Jon

[devinemke]

1. what does [man]mysql_error[/man] have to say about your query?

2. your code assumes that register_globals is ON in your php.ini. is it?

[Jon12345]

I've been to the link you have suggested and tried stuff but just can't figure out how to alter my code to display the MySQL error.

Any suggestions?

[devinemke]

mysql_query("UPDATE products SET Product='$Product', MetaTitle='$MetaTitle', CategoryID='$CategoryID', Data='$Data', WHERE ProductID='$ProductID'") or exit(mysql_error());

[Jon12345]

That worked. I get an error now. See below:

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 'WHERE ProductID='1'' at line 1

Any suggestions?

[Matt_Kindig]

Maybe the extra comma in your column select is causing a problem? Trying replacing with:

mysql_query("UPDATE products SET Product='$Product', MetaTitle='$MetaTitle', CategoryID='$CategoryID', Data='$Data' WHERE ProductID='$ProductID'") or exit(mysql_error());

Note no comma after the '$Data'

[flk]

Is ProductID a numeric field? If so try removing the single quotes around the variable $ProductID. So it looks like this ProductID=$ProductID. I'm pretty sure in SQL statements numeric fields do not get quotes around them. Hope this helps.

[Jon12345]

I removed the comma and its working now. Thank you so much!