help selecting from database to a table.

iv got a problem, im trying to select all from a table i have in oracle. i can do this but the table it gets outputted to is not working correctly.

http://ivy.shu.ac.uk/~rbundred/assignme … comnew.php

here is the problem and the code is below.

[code]$query=“select * from Accommodation”;
$stmt=ociparse($conn,$query);
ociexecute($stmt);
$nofields=ocinumcols($stmt);

print “

”;
while(ocifetchinto($stmt,$row))
{

for($i=1;$i<=$nofields;$i++)
{
print “

";
}

print “

”;
$i=0;
while($i<$nofields)
{
	print "<td>".$row[$i]."</td>";
	$i++;
}

}

?>

[/code]
”.ocicolumnname($stmt,$i)."

Link gives me a 404 error.

Sponsor our Newsletter | Privacy Policy | Terms of Service