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 had
4, 2004 10:43 AM
To: Eve Atley; [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 i
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 previ
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
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 do
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 &