Missing last record ?

[DaveinLondon]

My list always misses off the last record !

Is it normal that this coding shows up to the penultimate record
and does not list the last one ?

How do i get all of them to list ?

Many thanks.

$result = mysql_query($sql)
or die ("Could not execute MAIN query.");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC) )
{
extract($row);
require("homes_list.php"); // some code that prints out the details.
}

[ShrineDesigns]

without the sql statement there is little help anyone can offer

[DaveinLondon]

Thanks - I have got to the root of the problem!

I am using a LIMIT and had initated it at 0 but
my script was adding 1 to it before the query so
the listing started with the second record. My ORDER
stmt made it look like I was missing the last
record because my test dat only had 2 rows !

thanks anyways !