I use GoLive to create my web sites and I am a little new to PHP and how it interacts with MySQL databases. Do any of you use GoLive. I can really use some help, because the Adobe Forums are horrible and the help is not timely.
Moreover, would anyone know where some sites are dedicated to GoLive and PHP help?
Here is my first issue - I need to have my results from a query grouped like this:
GROUP ONE
Title1
Title2
Title3
Title4
Title5
GROUP TWO
Title1
Title2
Title3
Title4
Title5
What would the string be for this?
GoLive 6 and PHP
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
How you write your SQL statement would be dependent on how the data is stored in the database. It's likely that you probably just want to have an ORDER BY clause in the SQL though:
Mac
Code: Select all
SELECT field1, field2, field3 FROM table ORDER BY group