[RESOLVED] debugging correct mysql statement

[shifty18]

I am having a mysql error of

"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 1"

But i have sevral on die statments in my page, is there anyway to try and distinguise which mysql statement it is. I notice the code is or die (mysql_error()) can i put anything inthe () to try and show which error it is like a number, i did try a number but that just errored or is it a simple remove the on die and try again till you find the one thats erroring

Thanks
Chris

[Drakla]

yes use something like

die(mysql_error() . ' found on line: ' . __LINE__);

LINE is a magic constant that will get replaced with the line number. Take a look in the echo lounge for a thread called 'hidden php functionality' or something like that for more info.

[shifty18]

ahh worked great, now i jsut gotta figure out whats wrong with that line lol. Ill check out this thred you mention

nice sig aswell lol