[SOLVED] Query or die redirect page???

[phpinfo()]

I have a function that dies and gives a message if there is a MySQL error:

 

	
$result=mysql_query($query,$id) or die ("Unable to execute query \"".$query."\": ".mysql_error()); 

 

Is there a way to have it die and redirect to an error page instead of just giving an error message? I tried the below code, but I kept getting a too many redirects error from my browser:

 

	
$error_page = 	header('error.php'); exit(0);
$result=mysql_query($query,$id) or die ($error_page); 

 

 

 

[kenrbnsn]

Did you try:

<?php
$result=mysql_query($query,$id) or header('error.php');
?>

You might want to store the error in a session variable that can be picked up on the header page:

<?php
session_start();
$result=mysql_query($query,$id);
if (!$result) {
    $_SESSION['db_error'] = mysql_error();
    $_SESSION['db_query'] = $query;
    header('error.php');
    exit();
?>

 

Ken

[bluesoul]

$result=mysql_query($query,$id) or die ('<META HTTP-EQUIV="Refresh" CONTENT="0;URL=error.php">');

[revraz]

Or yet another idea to try

 

$result=mysql_query($query,$id);

IF (!$result){

header ("location: error.php");

}

[phpinfo()]

$result=mysql_query($query,$id) or die ('<META HTTP-EQUIV="Refresh" CONTENT="0;URL=error.php">');

 

 

Thanks, the meta redirect works perfect.

[bluesoul]

Good to know since I didn't actually test that code.