page empty ??

[netmastan]

I am having strange problem..the following code works at local server but it does not work on webserver.It just show empty page. I have checked table,database information etc..

Anyone knows what's the problem..

<?
require_once("mainfile.php");

global $dbi;

$month=date("m");
$year=date("Y");
$day=date("d");

/* Auckland location=1,Hamilton location=2,Wellington location=5 */

$res = sql_query("select location,month,date,day,Fajor,sunrise,Zuhr,Asr,Magrib,Isha from salat where date='$day' AND month='$month'", $dbi or die ("Database Error");
while(list($location,$month,$date,$day,$Fajor,$sunrise,$Zuhr,$Asr,$Magrib,$Isha) = sql_fetch_row($res, $dbi)){

$Fajor=trim($Fajor);
$sunrise=trim($sunrise);
$Zuhr=trim($Zuhr);
$Asr=trim($Asr);
$Magrib=trim($Magrib);
$Isha=trim($Isha);
if ($location==1 ) {
$location="Auckland";
$color="5500|1D3891|FFDD95|FFFFFF|212121";
}
 if ($location==2 ) {
 $location="Hamilton";
 $color="5500|1D3891|FFDD95|FFFFFF|212121";
}

if ($location==5 ) {
 $location="Wellington";
 $color="5500|008040|FFDD95|FFFFFF|212121";
}


echo "§$location|Fajor:$Fajor Sunrise:$sunrise Zuhr:$Zuhr ASR:$Asr Magrib:$Magrib Isha:$Isha| |$color<br>";

}


?>

[hand]

I heard about functions like
cyrus_query
fbsql_db_query
fbsql_query
ibase_query
msql_query
mssql_query
mysql_db_query
mysql_query
pg_query
sesam_query
ifx_query
sybase_query
but I never heard about a function like sql_query or sql_fetch_row. Which database are you using?

$res = sql_query("select location,month,date,day,Fajor,sunrise,Zuhr,Asr,Magrib,Isha from salat where date='$day' AND month='$month'", $dbi) or die ("Database Error");

Is it possible that your function needs a ) in front of "or die ("Database Error");"

Is $dbi set correctly?

[netmastan]

hi, thanks for the reply. I am using phpnuke. It handle sqly_query..

Even the following code does not work. It shows empty page.

<?
require_once("mainfile.php");

global $dbi;

$month=date("m");
$year=date("Y");
$day=date("d");

/* Auckland location=1,Hamilton location=2,Wellington location=5 */

$res = mysql_query("select  location,month,date,day,Fajor,sunrise,Zuhr,Asr,Magrib,Isha from salat where date='$day' AND month='$month'", $dbi);
 while(list($location,$month,$date,$day,$Fajor,$sunrise,$Zuhr,$Asr,$Magrib,$Isha) = mysql_fetch_row($res, $dbi)){

$Fajor=trim($Fajor);
$sunrise=trim($sunrise);
$Zuhr=trim($Zuhr);
$Asr=trim($Asr);
$Magrib=trim($Magrib);
$Isha=trim($Isha);
if ($location==1 ) {
$location="Auckland";
$color="5500|1D3891|FFDD95|FFFFFF|212121";
}
 if ($location==2 ) {
 $location="Hamilton";
 $color="5500|1D3891|FFDD95|FFFFFF|212121";
}

if ($location==5 ) {
 $location="Wellington";
 $color="5500|008040|FFDD95|FFFFFF|212121";
}


echo "§$location|Fajor:$Fajor Sunrise:$sunrise Zuhr:$Zuhr ASR:$Asr Magrib:$Magrib Isha:$Isha| |$color<br>";

}


?>