MySQL Query Issues [Help]

[Innovati0n]

I'm having problems with displaying mysql querys.

It's working fine, it's displaying, but not the first row. I've tried everything but its displaying from the second row down.

The code im using to display the rows is:

<?php
$query = ("SELECT * FROM message ORDER BY id LIMIT 0, 7"); 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
while($row = mysql_fetch_array($result)){
	echo "<div id='message'>";
	echo $row['message'];
	echo "</div>";
}
?>

 

[sachav]

Solution 1 - Remove line #4 (I don't see what's its use anyway)

<?php
$query = ("SELECT * FROM message ORDER BY id LIMIT 0, 7"); 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
    echo "<div id='message'>";
    echo $row['message'];
    echo "</div>";
}
?>

Solution 2 - Rewind the internal cursor

<?php
$query = ("SELECT * FROM message ORDER BY id LIMIT 0, 7"); 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result) or die(mysql_error());
mysql_data_seek($result, 0);
while($row = mysql_fetch_array($result)){
    echo "<div id='message'>";
    echo $row['message'];
    echo "</div>";
}
?>

 

[Innovati0n]

You are a legend, thanks a million, works fine now.