Looping?
| From: | Steve Jackson | Date: | Sat, 05 Oct 2002 12:56:33 +0000 |
| Subject: | Looping? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-118950@lists.php.net to get a copy of this message | ||
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++;
}
?>