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