Page 1 of 1

php code problem

Posted: Wed Apr 07, 2010 10:28 am
by sanya
[b]can sumbody tell me wats the problem in ma code[/b]
[b]why it is showing output s1 equals 0 everytime[/b]
<?php
require("page.inc");
$login=new page();
$login->setcontent("<p>ds</p>");
$login->display();

$pg=pg_connect('dbname=java1 user=aanchal password=aakash77');

if(!$pg)
{
echo "cannot connect to the database.";
exit;
}
$query="select status from status";
$result=pg_query($pg,$query);


if(!$result)
{
echo "cannot run query.";
exit;
}


if($result)
{
for($i=0; $i<pg_num_rows($result);$i++)

{
$row=pg_fetch_array($result,$i);
$s1=($row["status"]);
echo"$s1";
switch ($s1) {
case 0:
echo "s1 equals 0";
break;
case 1:
echo "s1equals 1";
break;
case 2:
echo "s1 equals 2";
break;
}


}


}



?>
[b]why it is showing output s1 equals 0 everytime[/b]
???????????????????????