Re: debugging?

Ok now that I can see the error message how can I fix it... the syntax looks correct and the error I am recieving is as follows.... You have an error in your SQL syntax near '= 'id'' at line 1 And this is my statement, $sql = mysql_query("DELETE FROM $table_name WHERE $id = 'id'",$dbh) or die(mysql_error()); Is there anywhere on php.net or mysql.org that give exact error meanings? Thanks again, Jas "Olinux" <olnx@yahoo.com> wrote in message news:20020221210839.52046.qmail@web11805.mail.yahoo.com... > jas, > > Try this: > - Remove the @, it suppresses the error > - change die("Could not execute query, please try > again later"); to die(mysql_error()); > > > $sql = mysql_query("DELETE FROM $table_name WHERE $id > = 'id'",$dbh) or > die(mysql_error()); > > olinux > > --- jas <jlgerfen@hotmail.com> wrote: > > Can someone tell me how I can find out why I am > > getting errors executing > > queries when I try to delete items from a table? I > > have 2 files... > > file 1. - Queries database, displays results with > > option to delete record > > using a check box, code is as follows... > > <?php > <snip> > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com