Dreamweaver - sql help

Author

sql help

lawrie

2004-03-03, 9:29 am

Hi,
I am creating a business directory using php/mysql.

I can create a recordset filter that can produce categories alphabetically:

http://www.fluffhill.co.uk/test.php

but I want to be able to set the aql sort so that categories can be listed
in groups:

A to D, E to H. etc.....

appreciate any help here

thanks

lawrie

Julian Roberts

2004-03-03, 10:29 am

You could have some SQL like

....
where left(field,1) >= 'a' and left(field,1) <= 'd'

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

lawrie

2004-03-03, 10:29 am

"Julian Roberts" wrote

: You could have some SQL like

: where left(field,1) >= 'a' and left(field,1) <= 'd'

thanks :-)

that works perfectly

Don't suppose there are any commercial packages that that deal with this
sort of data management?

cheers
lawrie
:

Julian Roberts

2004-03-03, 10:29 am

Not really. It's SQL and you'd need to learn it :)

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

lawrie

2004-03-03, 11:29 am

"Julian Roberts" <news@charon.co.uk> wrote in message
news:c24piv$9bp$1@forums.macromedia.com...
: Not really. It's SQL and you'd need to learn it :)
:
:-)