Data missing from php table

[dmanghani]

I have a mysql table where one record is missing from display in php. The table has 400 records. If is run a select * the record shows, if I run with a WHERE coloum=xxx the record shows.

The record is used in calculations so the data end result is wrong by that value, what could be the reason?

if i run this in a sql window this record does not show

the php/sql command is

 $query = "SELECT * FROM sundry  WHERE s_status IS NULL ORDER BY sdate ASC LIMIT $start_from, $per_page_record";

in the php display form one data is repeated

[chorn]

take away all limits, order by and where and have a look if it shows up.