I have this database which has 2 tables. I want to retrieve everything out of one column in each table.
I have set everything up and the first while loop works fine but the last while loop does nothing, not even a error message.
Here is the code:
<?php
$facilities_result=mysql_query("SELECT * FROM tbl_facilities WHERE id='$club'");
$todays_result=mysql_query("SELECT * FROM tbl_activities WHERE id='$club'");
?>
<?php
while($facilities_row=mysql_fetch_array($facilities_result))
{
echo(" ".$facilities_row["name"]);
}
?>
<br>
<br>
<b>Todays Activities</b><br>
<?php
while($todays_row=mysql_fetch_row($todays_result))
{
echo($todays_row["name"]."</br>");
}
?>
Thanks in advanced,
Joe