need help with why is data not displaying in table correctly

[kappaluppa]

I have a db.
Several entries are made with common a eventcode.
Each entry is also assigned a number (sesnumb) (numbers are not automatically generated)

I'm outputting the list to a table, but the first one, with number 1 does not show on the list.

THere are four entries in the db, but only 3 show up.

I am using:
"SELECT *, DATE_FORMAT(agenda_date , '%m-%d-%Y') AS date_format FROM calendar2 where eventcode LIKE '$eventcode%' ORDER by sesnumb";

any clues?????

Thanks!
K

[kappaluppa]

i added another record with same eventcode, but with sesnumb field blank.

it made the record with sesnumb=1 show up.

don't have the foggiest idea why!