Re: Looping?

typo: Justin French wrote:

This should get you started: <? $dbreturn = mysql_query("SELECT * FROM Items WHERE ItemID = '$ItemID'"); echo mysql_error(); $ItemHits = mysql_numrows($dbreturn); mysql_num_rows()

while($row = mysql_fetch_array($dbreturn)) { $ItemID = $row['ItemID']; $ImageName = $row['ImageName']; $ItemName = $row['ItemName']; $ItemSKU = $row['ItemSKU']; $ItemCost = $row['ItemCost']; $ItemDescription = $row['ItemDescription']; echo "<table width='400' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><img src='images/$ImageName' width='175'></td>"; echo "<td valign='top'>"; echo "<table width='225' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Product Name:</span></td>"; echo "<td><span class='pikkuleipa'>$ItemName</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Product Code:</span></td>"; echo "<td><span class='pikkuleipa'>$ItemSKU</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Unit price:</span></td>"; echo "<td><span class='pikkuleipa'>¬$ItemCost</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'><b>Description</b></span><br></td>"; echo "</tr>"; echo "<tr>"; echo "<td>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "<table width='225' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>$ItemDescription</span></td>"; echo "</tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "<form method='post' action='$Relative/addcart.php'>"; echo "<table width='400' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td width='175' align='right'><span class='pikkuleipa'>Quantity Required:</span></td>"; echo "<td width='225'>"; echo "<INPUT TYPE='TEXT' Name='ItemQuantity' Value='1' size='2'>"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td width='175'></td>"; echo "<td width='225'><input type='image' border='0' name='submit' src='images/add.gif'></td>"; echo "</tr>"; echo "</table>"; echo "</form>"; } ?> Justin on 05/10/02 10:56 PM, Steve Jackson (steve@webpage.co.uk) wrote:

Anyone help me? this is probably quite simple but I'm pretty new to PHP. All I want to do it loop through some DB records and display them in the format written in this PHP file: Anyone see where I'm going wrong? the error I get says: Warning: Unable to jump to row 0 on MySQL result index 2 <? $dbreturn = mysql_query("SELECT * FROM Items WHERE ItemID = '$ItemID'"); //debug echo mysql_error();

$ItemHits             = mysql_numrows($dbreturn);
$ItemID             = mysql_result($dbreturn ,$i,"ItemID");
$ImageName            = mysql_result($dbreturn ,$i,"ImageName");
$ItemName            = mysql_result($dbreturn ,$i,"ItemName");
$ItemSKU            = mysql_result($dbreturn ,$i,"ItemSKU");
$ItemCost            = mysql_result($dbreturn ,$i,"ItemCost");
$ItemDescription            = mysql_result($dbreturn ,$i,"ItemDescription");

for ($i=0; $i < $ItemHits; $i++) //($i < $ItemHits) { $row = mysql_fetch_array($dbreturn); echo "<table width='400' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><img src='images/$ImageName' width='175'></td>"; echo "<td valign='top'>"; echo "<table width='225' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Product Name:</span></td>"; echo "<td><span class='pikkuleipa'>$ItemName</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Product Code:</span></td>"; echo "<td><span class='pikkuleipa'>$ItemSKU</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>Unit price:</span></td>"; echo "<td><span class='pikkuleipa'>¬$ItemCost</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='pikkuleipa'><b>Description</b></span><br></td>"; echo "</tr>"; echo "<tr>"; echo "<td>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "<table width='225' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td><span class='pikkuleipa'>$ItemDescription</span></td>"; echo "</tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "<form method='post' action='$Relative/addcart.php'>"; echo "<table width='400' border='0' cellspacing='0' cellpadding='0'>"; echo "<tr>"; echo "<td width='175' align='right'><span class='pikkuleipa'>Quantity Required:</span></td>"; echo "<td width='225'>"; echo "<INPUT TYPE='TEXT' Name='ItemQuantity' Value='1' size='2'>"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td width='175'></td>"; echo "<td width='225'><input type='image' border='0' name='submit' src='images/add.gif'></td>"; echo "</tr>"; echo "</table>"; echo "</form>"; //$i++; } ?>