Ok jas > 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?
Possible confusion between PHP code and SQL. Do you really mean "...WHERE id = '$id' "? =dn > Thanks again, > Jas > "Olinux" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 <[EMAIL PROTECTED]> 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php