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