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 ([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
