2. PHPRunner General questions
  3. Create Tables from Table
This topic is locked

Create Tables from Table

 		11/23/2010 7:28:59 PM
PHPRunner General questions
author

I have a table that lists all my Labs. I want to create from it two tables - one that will list active dogs and one that will list those that are retired from my breeding program. Is there a way to create these tables then have php create a separate list page for each of them rather than a list page that includes all of them?
J
 		joker 11/24/2010



I have a table that lists all my Labs. I want to create from it two tables - one that will list active dogs and one that will list those that are retired from my breeding program. Is there a way to create these tables then have php create a separate list page for each of them rather than a list page that includes all of them?


You could create individual views for each dog breed and alter each of the SQL statements.
[First View]

SELECT Column_Names

FROM Table_Name

WHERE Dog_Breed=Breed1


[Second View]

SELECT Column_Names

FROM Table_Name

WHERE Dog_Breed=Breed2