a mysql skip function

[PC Nerd]

hi guys....

 

 

i want to have a function, where i can go something liek:

 

if mysql has error, {

 

mysql_status_enable = 0;

 

}

 

this way, it would cancel all funtions and variables relying on anything to do with the database....... and even replace those values, with something like "ERROR"

 

 

is there a function or a way to do this?

 

 

 

PS

 

im not looking for a simply or die(); statement

 

 

 

thanks

[taith]

<?
function db_query($query){
global $dbdisable;
if($dbdisable==1) return;
$result=mysql_query($query) or $dbdisable=1;
return $result;
}
?>

[chigley]

A simpler way without a function would be:

 

<?php

$query = mysql_query("SELECT * FROM table") or mysql_close();

?>

[taith]

that works too... lol...

[PC Nerd]

 

so will mysql_close actually cancel all mysql stuff, or will the rest of the functions  eg the rest of the queries, actually get a no connection error, or whatever.?

 

 

thanks for your help,

[chigley]

mysql_close closes the connection with MySQL so any future queries will not be able to run because there are no connection details availiable. Alternatively you can do this:

 

<?php

$query = mysql_query("SELECT * FROM table") or $error = true;

/* Future queries... */

if(!$error) {
$query2 = mysql_query("SELECT * FROM table2") or $error = true;
}

?>

[PC Nerd]

ok, greatm thnks for your help..

 

 

 

is there any other way, to go it gloablly, like an event handeler or something liek:

 

 

on mysqli_error() mysqli_ = 0;

 

to cancel anything using mysqli_.......... if there is an error cauased by =it, and to possibly set it to mute "@" the error?

 

 

cani do it that way? like in my ini file, or .htaccess on my login with my host etc.?

 

 

thanks

[taith]

i highly doubt it...

[PC Nerd]

ok, no problem, thanks anyway

 

ill leave this open, in case anyone knows of a way to do it.