From: Eve Atley [mailto:[EMAIL PROTECTED]
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
; [EMAIL PROTECTED]
Subject: RE: Need correct 'order by' syntax where field does not contain
NULL
From: Eve Atley [mailto:[EMAIL PROTECTED]
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
Mike Johnson wrote:
From: Eve Atley [mailto:[EMAIL PROTECTED]
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
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 =
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
WHERE id = id = '$category.' AND active ='y' AND order is not NULL ORDER
by order,title
-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 2:24 PM
To: [EMAIL PROTECTED]
Subject: Need correct 'order by' syntax where field does not contain
NULL