Member Avatar for 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().

Edited by shahai.ali because: some error was there
  • 3 Contributors
  • 4 Replies
  • 613 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by shahai.ali
Member Avatar for NardCake

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

Member Avatar for shahai.ali

this not help me accurately

Member Avatar for 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.

Member Avatar for shahai.ali

Thnx adamadamski96155 its working here

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.