Entry

when my query returns more than 1 record. How do i loop thru it and display all records on page ?...

Aug 12th, 2002 18:07
Delaney Hee Kuan Weng, Ram Kuntamukkala, thyokel

try this,
for($i=0;(2501>$i && $i <=$nrows);$i++)
{
        $varItem=substr($results[SEGMENT1][$i]);
	$varDescription=$results[DESCRIPTION][$i];
	$varOrderNumber=$results[ORDER_NUMBER][$i];
	$varCustomerName=$results[CUSTOMER_NAME][$i];
	$varCustomerPoNumber=$results[CUST_PO_NUMBER][$i];
	$varShippedQty=$results[SHIPPED_QUANTITY][$i];
	$varCurrencyCode=$results[TRANSACTIONAL_CURR_CODE][$i];
	$varSellingPrice=$results[UNIT_SELLING_PRICE][$i];
	$varListPrice=$results[UNIT_LIST_PRICE][$i];
	echo "<tr><td width='7%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varItem</font></td>
	<td width='43%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varDescription</font></td>
	<td width='5%' align=left valign=top  
bgcolor='#D3DDEE'><font>$varOrderNumber</font></td>
        <td width='20%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varCustomerName</font></td>
	<td width='5%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varCustomerPoNumber</font></td>
	<td width='5%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varShippedQty</font></td>
	<td width='5%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varCurrencyCode</font></td>
	<td width='5%' align=left valign=top 
bgcolor='#D3DDEE'><font>$varSellingPrice</font></td>
	<td align='5%' left valign=top 
bgcolor='#D3DDEE'><font>$varListPrice</font></td></tr>";
}