Maybe you have make a mistake like this:
$query="select from table_name";
$result=mysql_query($query);
if(!($row=mysql_fetch_array($result)))
{
//have no records, do something;
}
else while($row=mysql_fetch_array($result)))
{
/display you records,but it not include the first record*/
}
because the first '$row=mysql_fetch_array($result)' has just get the first record.When you do loop in the while,in fact,it bigin with the secondly record.
So you can whrite you code like this:
$query="select from table_name";
$result=mysql_query($query);
if(!($row=mysql_fetch_array($result)))
{
//have no records, do something;
}
$result=mysql_query($query);
while($row=mysql_fetch_array($result)))
{
/display you records,but it not include the first record*/
}
