Page 1 of 1

Only displaying single rows value

Posted: Mon Mar 17, 2003 7:35 am
by ridwan
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 :

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")........
Does anyone know why this is so?? :?

Posted: Mon Mar 17, 2003 7:39 am
by twigletmac
Please don't cross-post. Choose the most relevant forum for your question and post there. If you feel you initially posted your question in the wrong forum, delete the first post before reposting.

Anyone wishing to help:
viewtopic.php?t=7261&highlight=

Mac