row 0 not showing in results

[ro1960]

I have 3 matching records for my query (they show normally in phpMyAdmin) but with my PHP code only rows 1 and 2 show.

Why is row 0 not showing? What is wrong with my code below?

<?
include("XXXXXXXX");

$connection = mysql_connect($host,$user,$password)
or die ( mysql_error() );
$db = mysql_select_db($database,$connection)
or die ( mysql_error() );
$query = " SELECT * FROM mag_toc
WHERE category='30'
AND date_archive='$q_date'";
$result = mysql_query($query)
or die ( mysql_error() );

$row = mysql_fetch_array($result);
if($row)
{
extract($row);
echo "<p class=\"header-burgundy\">Weekly News from Investment & Technology</p>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo"<p>
<b>".$title."</b><br />".
$description."<br /><a href=\"http://www.investmenttechnology.com.au/body/article_view.php?id=".$id."\">read more...</a></p>";
}
}

?>

[djones]

When you call:
$row = mysql_fetch_array($result);
you are fetching the first row and advancing to the next row. You do not display any data from it and then you call:
while ($row = mysql_fetch_array($result))
to get the remaining rows. This is why you are losing the first row of data.

Hope this helps.

[ro1960]

OK so what would be the correct syntax to get display all the rows?

[swiftone]

I am posting this quickly, and may be wrong, but will this work?

include("XXXXXXXX");

$connection = mysql_connect($host,$user,$password) or die ( mysql_error() );
$db = mysql_select_db($database,$connection) or die ( mysql_error() );
$query = " SELECT * FROM mag_toc WHERE category='30' AND date_archive='$q_date'";
$result = mysql_query($query) or die ( mysql_error() );
$row_result = mysql_fetch_assoc($result);

if($row_result) {
    do {
        echo"<p><b>".$title."</b><br />".$description."<br /><a href=\"http://www.investmenttechnology.com.au/body/article_view.php?id=".$id."\">read more...</a></p>";
    } while ($row_result = mysql_fetch_assoc($result));
} 

[Imminent]

       $result = mysql_query($query);
  if (mysql_num_rows($result) > 0) {
    // at least one row has been returned
    while ($row = mysql_fetch_array($result)) {
      echo $row['title'] . '<br />'; // etc
    }
 }
 else {
 // no rows were returned
 } 

[ro1960]

Thanks it worked just fine!