[Rattlecage Demon]

$queryvariable = "delete from DATABASE.TABLE where (FIELDNAME='$SOMEVARIABLE' or OTHERFIELDNAME='$SOMEVARIABLE');";
MYSQL_QUERY($queryvariable);

This query works when put into PHPMyAdmin but not when the script is run. Any ideas why? Thanks.

Names have been changed for posting reasons.

[Keith]

Originally Posted by Rattlecage Demon

Names have been changed for posting reasons.

Like that would present any security issue to your sight of whose location and login credentials we have absolutely no idea...

Remove the first semi-colon on the query line, between the last parenthesis and last doube quote.

PHP Code:

$queryvariable = "delete from DATABASE.TABLE where (FIELDNAME='$SOMEVARIABLE' or OTHERFIELDNAME='$SOMEVARIABLE')"; 

[Rattlecage Demon]

Thanks for the smarm and wrong answer.

[Keith]

Oh yeah:

PHP Code:

$queryvariable = "delete FIELDNAME from DATABASE.TABLE where FIELDNAME='$SOMEVARIABLE' or OTHERFIELDNAME='$SOMEVARIABLE'";