Conditional direction to a page

Kinsley

I am new to PHP and a friend has given me this code to direct visitors to a different page depending on the SQL result but it simple goes to the "else" page irrespective of the condition. Can anyone tell me what I am doing wrong. Please.

<?
include("connect.php");
$sql = "Select * From qryAwards WHERE EventsID = $EventsID AND EventStatus = 'Active'";
$result = odbc_exec($connection, $sql);
// The line below checks to see how many rows of information are returned.
$number_rows = odbc_num_rows($result);
// If 1 or more rows are returned then we have some data so print the table:
if($number_rows >= 1){

	echo "<html><head>";

	echo  odbc_result($result,1) . " ";
	echo odbc_result($result,2) . " ";
	echo  odbc_result($result,3) . "<BR>";
}

else{
	header("Location: [url]http://localhost/sajjadsumar/failed.php[/url]");

}		
include("disconnect.php");

laserlight

Well, does $EventsID contain a value?

Kinsley

Yes, without the condition, it returns values

stovellp

I'm not sure, but I think
$sql = "Select From qryAwards WHERE EventsID = $EventsID AND EventStatus = 'Active'";
Might need to be:
$sql = "Select From qryAwards WHERE EventsID='$EventsID' AND EventStatus = 'Active'";

Ie, with quotes around $EventsID

I'm not sure if that will help though. Make the line read something like this:

$result = odbc_exec($connection, $sql) or die(mysql_error());

Although I'm not sure if that lines right, if it is it will tell you what the error was.

~ Paul

laserlight

quite would help if the variable doesnt contain numeric data only.

still maybe you should write in the check as stovellp suggested.

Kinsley

Thnx but quote is not required becos the script runs without the condition and the EventsID is integer . I feel it is around the position of the statement within html, I am new to html and not sure whether I have added the script in the write places. How else can I implement this objective, Could for instance use three pages, one to check and the other to direct to either of the pages, is the script below ok:

header("Location: [url]http://localhost/sajjadsumar/studentsfrm.php[/url]");

}

else{
	header("Location: [url]http://localhost/sajjadsumar/failed.php[/url]");

}		
include("disconnect.php");

?>

<html>
<head>

stovellp

The code should be ok AS LONG as the headers will be sent BEFORE any output (Ie, <html>) because if not It wont work. This includes any output coming from the included files.

Make your third line

$result = odbc_exec($connection, $sql) or die(mysql_error());

Which will tell you the error the MySQL query was encountering.

~ Paul