The same query returning two different results

[poisa]

Hi all,

I'm trying to delete an email address from a table. When I enter the query in phpMyAdmin's query window, it works fine.

When I enter it from PHP y doesn't work.

I even went to the extreme of getting rid of all the variables on the PHP query and just have a fixed string like:

$sqlQuery = "DELETE FROM maillist WHERE email = '[e-mail]'";

$result = mysql_query($sqlQuery, $db);

if ($result){
    echo "Record deleted<BR>";
} else {
    echo "Record NOT deleted<BR>";
}

Still not working.

I'm using phpMyAdmin 2.5.1, mySQL 4.0.13, and PHP 4.3.2

Any ideas?

<edit>forgot PHP's version</edit>

[bad76]

Hi,
ask to mysql_error()

[poisa]

bad76, thanks for the info. I didn't know of that function.

It solved my problem. It was actually that they user didn't have enought privileges to delete.

Thanks!