[SOLVED] Stupid problem - with null values

[richrock]

Hi, having a small issue with a MySQL statement :

 

$querycbpro = "SELECT id, firstname, lastname FROM jos_comprofiler ORDER BY lastname WHERE lastname IS NOT NULL";

 

But I get a syntax error near WHERE lastname....

 

Any ideas why?  If I remove the WHERE... IS NOT NULL, it works, but inserts a load of NULL values.  I want to ignore these.  The database was pre-set with the NULL value on the rows, so I can't do much about that.

 

Thanks

 

Rich

[rhodesa]

Edit: oops...WHERE needs to be before ORDER

 

$querycbpro = "SELECT id, firstname, lastname FROM jos_comprofiler WHERE lastname IS NOT NULL ORDER BY lastname";

 

 

[richrock]

I should have realised.  Duh. 

 

Thanks guys