How to store error of mysql_error() in a php variable??

[shahai.ali]

hi all i want to store the error of mysql_error() in a variable. i was trying the following:

    $alert_error = "<script type=\"text/javascript\"> alert('".mysql_error()."') </script>";
    $id =5;
    $query = mysql_query("DELETE FROM abc WHERE id ='$id'") or die ($alert_error);

actually my there is a foreign key constraint so when i click to delete it the mysql_error()display an error but i want overwrite that error using alertbox().

[NardCake]

$variableName = mysql_error($connection);
if you don't specify your connection it will just use the last one opened.

[shahai.ali]

this not help me accurately

[adam.adamski.96155]

$alert_error = "<script type=\"text/javascript\"> alert('".mysql_error()."') </script>";
In the above line you are referencing 'mysql_error()', but it doesn't exist yet because you did not run the query that produces the error.
Also, you wanted Javascript to alert the value of 'mysql_error()':

if (!$query = mysql_query("DELETE FROM abc WHERE id ='$id'")){
    echo "<script type=\"text/javascript\"> alert('".mysql_error()."') </script>";
    }

The above works when I test it.

[shahai.ali]

Thnx adamadamski96155 its working here