MySQL statement

graham

This MySQL statement fails, but I can't see why

$sql = "DELETE FROM delivery_address WHERE (id = '$webuser') AND (title = '$delete_title') AND (first_name = '$delete_first_name') AND (last_name = '$delete_last_name') AND (address_line_1 = '$delete_address_line_1') AND (address_line_2 = '$delete_address_line_2') AND (address_line_3 = '$delete_address_line_3') AND (address_line_4 = '$delete_address_line_4') AND (town = '$delete_town') AND (postcode_zip = '$delete_postcode_zip') AND (country = '$delete_country') AND (telephone = '$delete_telephone')";
$result = mysql_query($sql, $connection) or die ('Cannot delete delivery addresss as requested.');

Any ideas welcome. Thanks! Graham

Anon

What error messages are you getting, if any?

graham

The statement returns the 'or die' message and fails to complete it's task.
The page in question first reads in all the delivery addresses from MySQL and the user selects one to delete via a checkbox. The data is plopped into hidden fields within each address section (each section being a seperate form). A Javascript function changes the contents of a hidden field 'edit_flag' from the value 'no' to 'yes' within that section (form). The page is then posted to itself and a if ($edit_flag) routine then issues the MySQL delete statement as in the oroginal message to the forum. The data should match and therefore delete that record. But it doesn't for some reason :-(

Anon

Do the rows in the table have a field, in which a value is stored that is unique to that row? If they do, try issuing a query that deletes a row based on that value i.e. $Query = "DELETE from dilivery_address WHERE fieldName = 'uniqueFieldValue'";

To track down the problem try writing the $result statement like so:

if(!($result = mysql_query($sql, $connection))) {
print("Can't perform query!<br>\n");
print("MySQL Reports: " . mysql_error() . "<br>\n");
}

This will give you a MySQL error message that you can work from.

I hope this is useful!

[deleted]

Let MySQL tell you why, change your "or die" line to this:

if (!mysql_query($sql, $connection))
{

query failed

echo mysql_error();
echo "\n$sql\n";
};

graham

Thanks for that suggestion. I did just that and received an error telling me that access is denied for that user. I checked the user file for mysql and ensured that the user has Delete_priv set to 'Y'. It did, you I'm wondering why this is happening. The same user / password/ host is used thoughout the project without error (until this).

graham

FOUND IT!

The 'mysqladmin reload' command had not been run to update the user table after alteration. DOH!!!!
Sorry for being so stupid. Time for some R&R I think.