multiple viewing of mysql data
Posted: Wed Jan 18, 2006 5:27 am
I have a business directory in the making. I am having problems with displaying the results.
When a query is executed I can return the basic details I have asked for, however I wish for a few extras to be viewable.
I have 2 database entry types:
- Basic Entry
- Advanced entry
All of there details are stored in the same table with one column titled 'paid'. If the business is an advanced entry the row will state 'paid', if they are a basic entry it will state 'unpaid'.
All good so far....
So, when the query is executed I firstly want to display the following details for advanced listing:
Business Name
Address
Telephone
Fax
Email
Website
Features
Category
and then followed by the basic entry details:
Business Name
Address
Telephone
Category
In regards to the order, that is easy enough, but how do i display the 2 separate results together. i have managed to get it to work and be able to view one or the other but not together.
Can anyone help?
Cooper
When a query is executed I can return the basic details I have asked for, however I wish for a few extras to be viewable.
I have 2 database entry types:
- Basic Entry
- Advanced entry
All of there details are stored in the same table with one column titled 'paid'. If the business is an advanced entry the row will state 'paid', if they are a basic entry it will state 'unpaid'.
All good so far....
So, when the query is executed I firstly want to display the following details for advanced listing:
Business Name
Address
Telephone
Fax
Website
Features
Category
and then followed by the basic entry details:
Business Name
Address
Telephone
Category
In regards to the order, that is easy enough, but how do i display the 2 separate results together. i have managed to get it to work and be able to view one or the other but not together.
Can anyone help?
Cooper