Only displaying single rows value
Posted: Mon Mar 17, 2003 7:35 am
I am using the following code to run through a table and show me all of it's rows but I only get a single row displayed :
Does anyone know why this is so?? 
Code: Select all
$strSQL = "SELECT * FROM suppliers ORDER BY їContentId]";
$result= odbc_exec( $dbConnection, $strSQL);
//get resultset and transform into object
While (odbc_fetch_row($result)); {
//retrieve needed info from object
echo "<tr><td>" . odbc_result($result, "ContentId") . "</td><td>" . odbc_result($result, "Name")........