doing something like if( $sql->query('') {..

[play_]

I haev an SQL class.

Here's what the query method looks like:

 

function query($query) {
	$this->result = @ mysql_query($query, $this->linkid);
	if(!$this->result) {
		echo "--[ query failed ]--";	exit();
	}
}

 

 

Now, I am doing something like this on another page:

$sql = new SQL();

$query = "query here";
if( $sql->query($query) ) {
header("Location: " . $_SERVER['PHP_SELF'] . "?result=success");
} else {
echo 'problem';
}

 

 

The problem with the above is that the query is indeed being ran (i checked in the database), but the page is not redirecting

But the following works (it redirects):

 

$query = 'some query here';
$sql->query($query);
header("Location: " . $_SERVER['PHP_SELF'] . "?result=success");

 

In other words, if i take out the if statement, it works as intended. why?

[PFMaBiSmAd]

Your query function does not return anything (which probably results in a null value), so an if() test will be false. Change your function to return a true value if the query did not fail.

[roopurt18]

You should also usually call exit() after redirecting.

[play_]

thanks guys.

 

ps:: here is the topic solved button?