Here is what your delete statement should look like:
$sql = mysql_query("DELETE FROM $table_name WHERE id = '$id'",$dbh) or
die(mysql_error());
Note the field name without the $ in front of it and the variable you are
comparing it to with the $.
One other note, in your table, you have id as a varchar(30) auto_increment.
As far as I know, auto_increment can only be used on INT() field types,
unless I missed something there. If you do end up changing the field type to
INT, make sure you take the '' around the $id out.
HTH
MB
jas <[EMAIL PROTECTED]> said:
> 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
>
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
