Peter J. Boettcher — Fri, 11 Oct 2002 00:45:59 +0000

Mike,

You might want to start experimenting with paging, once you start getting too much data in your database your scripts will start timing out or take too long to execute.

fifeclub — Thu, 10 Oct 2002 04:39:14 +0000

Here's the experimental stuff I'm teaching myself with (although the actual data is real)

pstvalumni.com/directory/display2.php

None of the lastname or firstname fields are blank but a lot of the additonal columns contain blank fields.

Thanks for pointing me in the right direction. I'll try one of these suggestions next time I work on it.

mairving — Wed, 09 Oct 2002 17:52:18 +0000

Try

<?php
SELECT * from alumni2 
WHERE lastname <> 'NULL'
ORDER BY lastname, firstname;
?>

You really have a couple of options. You can try using something like WHERE lastname > '0', which works okay some of the time. I tend to prefer to set a default value 'NULL' for the field so that I can exclude by WHERE lastname <> 'NULL'. I guess the other question would be why do you have fields like lastname, firstname that are blank.

You could also make a conditional statement with PHP once you have all of your data.

Mark Hensler — Wed, 09 Oct 2002 17:47:49 +0000

You'll have to run two queries. The first query will omit the blank entries (with a WHERE clause), and the optional second query would retrieve the blank entries.