Re: [PHP] querying a database to sort ascending but list non null results first

On Wed, April 25, 2007 12:54 pm, Tasneem Qadeer wrote: > I hope you will take some time from your busy day to answer my > question. It's actually more of an SQL question, really However, getting the NULL results to be before/after the non-NULL results is fairly easy: select field1, field2, f

[PHP] querying a database to sort ascending but list non null results first

Hi, I hope you will take some time from your busy day to answer my question. Thank you in advance. I am new to php programming, so hope my question doesn't bore you. I am helping to develop an online directory. The database is set up with some of the data entries as "prime". These are the people