I can't link the two tables at all. I need to loop through one displaying its information, then loop through the other table displaying its information. For if I have 5 records in table A and 6 records in table B, I get 11 records total. Each table only has 4-5 fields and they exist in both table. The two tables have the same structure minus one field. The two tables should have been one table but I didn't design the database but have to make it work. Using I would use a view to make one master table then order it by the common date field. But MySQL doesn't have view let.
The reason I can't just display one table after the other is that I need the PHP page to have the results ordered by the common date field. I can't link the two tables together in the SQL. Mark. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
