can you have two sql statements on the same page.

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.