I've created this query but it never shows the first result. I can have any number of results and order them however I like but whatever the first result in the list is it doesn't appear.
Can anyone help me out, please?
Here's the code:
<?php
require_once ('../../mysql_connect_bargain.php'); // Connect to the database.
echo "<TABLE>";
$result = mysql_query("SELECT * FROM products ORDER BY date DESC");
$myrow = mysql_fetch_array($result);
while($myrow = mysql_fetch_array($result)) {
echo "<TR>";
echo "<TD width=\"300\">" . $myrow['product_name'] . "</TD>";
echo "<TD width=\"50\">" . $myrow['price'] . "</TD>";
echo "</TR>"; }
echo "</TABLE>";
?>
