This should get you started:
<?
$dbreturn = mysql_query("SELECT * FROM Items WHERE ItemID = '$ItemID'");
echo mysql_error();
$ItemHits = mysql_numrows($dbreturn);
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 ([EMAIL PROTECTED]) 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++;
> }
> ?>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
