odbc_fetch_row

[Ikem]

I have used this code but it does not work can somebody help meeeeeee!!!

<?php

include("connect.php");

$sql = "Select * From qryAwards WHERE EventsID = $EventsID AND EventStatus = 'Active'"; 

$result = odbc_exec($connection, $sql); 

 echo ("<table border=1 width=400>");

echo ("<tr><th>Ref Number</th><th>Title</th><th>Description</tr>");

while  ($MyRows = odbc_fetch_row($result) == true) {

	print ("<tr><td>$MyRows, 1</td><td>$MyRows, 2</td><td>$MyRows, 3</td></tr>");

	}

	echo ("</table>");	

include("disconnect.php");

?>

[Drakla]

Aye, I see ya jip. I odbc_fetch_row actually just returns true or false, not an array so you really want

while ($MyRows = odbc_fetch_row($result) == true) {

print ("<tr><td>$MyRows, 1</td><td>$MyRows, 2</td><td>$MyRows, 3</td></tr>");

}

while ( odbc_fetch_row($result) )
{
    echo "<tr><td>".odbc_result($result, 1)."</td><td>".odbc_result($res, 2)."</td><td>".... etc etc
}

Though I prefer to fetch into an array as I don't like the that that odbc_result has its index starting at 1 - so I use

while (odbc_fetch_into($res, $myArray))
{
    echo "<tr><td>$myArray[0]</td><td>$myArray[1]</td><td>".... etc etc
}

That should do ya.