while loop using MSSQL/ODBC

[mattock]

Hi
I'm trying to re-write a simple 'while' loop in php. I have had to transfer hosts, my old host had MYSQL and i could connect simply by using @mysql_connect. How ever, my new host is MS SQL and i have to connect using ODBC.

This is my old php code i'm trying to convert to MS SQL/ODBC

$result = @ ($query);
$row = @mysql_fetch_array ($result, MYSQL_NUM);
if ($result) {
while ($row = mysql_fetch_assoc($result)) {
echo $row['id'];
}
}

I have managed to connect to the database using ODBC ( $result = odbc_exec($conn, $query); ), but i'm not sure what syntax is needed to do the while loop! Any help is much appreciated

Thanks in advance

[etully]

This is code from one of my mssql sites:

	[CODE]$query = "select FirstName,LastName,Address1,Address2,City,State,Zip,Country,
			Phone,Fax,Email,ShippableShippingTotal,ShipMethod,uid,DeliveryDate,
			HandlingTotal,SpecialShippingMethod,SpecialInstruction,Company 
			from OrderAddresses where OrderID=$order_uid";
	$result = odbc_exec($connect, $query);

	$i = 0;   
	$contact_details = array();
	while(odbc_fetch_row($result)) {

		$contact_details[$i][1] = odbc_result($result, 1);
		$contact_details[$i][2] = odbc_result($result, 2);
		$contact_details[$i][3] = odbc_result($result, 3);
		$contact_details[$i][4] = odbc_result($result, 4);
		$contact_details[$i][5] = odbc_result($result, 5);
		$contact_details[$i][6] = odbc_result($result, 6);
		$contact_details[$i][7] = odbc_result($result, 7);
		$contact_details[$i][8] = odbc_result($result, 8);
		$contact_details[$i][9] = odbc_result($result, 9);
		$contact_details[$i][10] = odbc_result($result, 10);
		$contact_details[$i][11] = odbc_result($result, 11);
		$contact_details[$i][12] = odbc_result($result, 12); 
		$contact_details[$i][13] = odbc_result($result, 13);
		$contact_details[$i][14] = odbc_result($result, 14);
		$contact_details[$i][15] = odbc_result($result, 15);
		$contact_details[$i][16] = odbc_result($result, 16);
		$contact_details[$i][17] = odbc_result($result, 17);
		$contact_details[$i][18] = odbc_result($result, 18);
		$contact_details[$i][19] = odbc_result($result, 19);


	$i++;
	}[/CODE]

[mattock]

thanks for that, helped me out nicely! 😃