select * from navigation WHERE id = '".$category."' AND active='y' AND order IS NOT null ORDER BY order, title
> Hi. I had a MySQL DB set up and recently added a field 'order' to allow > for > exceptions in a web site menu heirarchy. Fields should be ordered by > 'order' > field first where it does not contain 'NULL', and then by field 'title'. I > had this previously: > > select * from navigation WHERE id = '".$category."' AND active='y' ORDER > BY > title > > ...and now, when I put in: > > select * from navigation WHERE id = '".$category."' AND active='y' ORDER > BY > order, title > > ...my menu shows nothing. How can I write my statement to allow for ORDER > by > order where 'order' does not contain 'NULL', and then title? > > Thanks, > Eve > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]