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

[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 club_name = '$id' ";

   //sql statement 2
        $sql2 = "select message,message_title from noticeboard where club_name =
'$id' ";

   //execute sql1 query and get results
      $sql_result1 = mysql_query($sql1);

   //execute sql2 query and get results
      $sql_result2 = mysql_query($sql2);

   /*results
      variables for data to be displayed*/

      while ($row = mysql_fetch_array($sql_result1)) {
                 $name = $row["club_full_name"];

            }


How can I put both sets of results in the while statement.

Any help would be kindly appreciated

Matt.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]