1.11M Members

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


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().


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


this not help me accurately


$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.

Question Answered as of 1 Year Ago by adam.adamski.96155 and NardCake

Thnx adamadamski96155 its working here

This question has already been solved: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: