why is one row missing

[abanana]

hi there,

to show some of the database data, i use the following script:

$result = mysql_query("SELECT * FROM users where name='$name' and joined='$date'") or die(mysql_error());  
$row = mysql_fetch_array( $result );
$total = mysql_num_rows($result); 
while($row = mysql_fetch_array($result)) 
{
echo $row['name'];
echo $row['joined'];
echo "<br>"
} 

the problem is it when $total = 10 (for example), it can only echo out 9 rows, the first row is missing.

any idea why?
thanks

[spikeZ]

I think it's because you are assigning 2 result handlers to the query....

$result = mysql_query("SELECT * FROM users where name='$name' and joined='$date'") or die(mysql_error());   
$total = mysql_num_rows($result); 
while($row = mysql_fetch_array($result)) 
{ 
echo $row['name']; 
echo $row['joined']; 
echo "<br>" 
} 

Should work

[ClickHeRe]

more like you were fetching the first row without printing it

$result = mysql_query("SELECT * FROM users where name='$name' and joined='$date'") or die(mysql_error());  
$row = mysql_fetch_array( $result ); <-- HERE 
$total = mysql_num_rows($result);
while($row = mysql_fetch_array($result))
{
echo $row['name'];
echo $row['joined'];
echo "<br>"
}

[spikeZ]

which in esscence assigns 2 handlers to one result......

[abanana]

thanks guys!

you both are right!

the code spikeZ modified worked. Cheers!

[spikeZ]

no worries