[PHP] can you have two sql statements on the same page.

2001-03-21 Thread Matt Davis
I want to extract 2 sets of data each from different tables in the same db but display the results on the same page at the same time. Can I just have two sql statements like this or do I need to do something else. //sql statement 1 $sql1 = "select club_full_name from clubs where

Re: [PHP] can you have two sql statements on the same page.

2001-03-21 Thread Jack Sasportas
The simple answer would be 2 while statements, but are you trying to mix the results or are you keeping them seperate? By mix there are 2 options value_db1 Value_db2 Value_db1 or value_db1 value_db1 value_db2 value_db1 by the simple answer above it would result in something like Category #1