[thelist] sql delete query error help

[Scott Brady]

---------- Original Message ----------------------------------
From: "Tom Dell'Aringa" <pixelmech at yahoo.com>
>SQL-query :
>DELETE prodtemp.prodName FROM prodtemp WHERE pid = 145

Try it changing "prodtem.prodName" to just "prodName" and see if that does it.

It's possible mySQL doesn't like the table "dot" notation in the Delete queries.

Scott