hey there guys..
i have the following code, that is trying to print out a bunch of live dates that are grouped by month so it would look kinda like:
August
Sunday 23rd....
monday24th...
September
monday 1st....
tuesday 2nd...
...
however, the following code only gives a few rows... when i know there are more. i cant really figure out what to try next...
any ideas?
$sql = mysql_query("SELECT * FROM live WHERE live_date > now() AND live_team > '0' GROUP BY MONTH(live_date) ORDER BY live_date ASC");
while($row = mysql_fetch_array($sql)) {
$live_date = $row["live_date"];
$live_id = $row["live_id"];
$live_city = $row["live_city"];
$live_Venue = $row["live_venue"];
$live_team = $row["live_team"];
list($year,$month,$day) = explode("-",$live_date);
$date1 = date("D jS", mktime(0,0,0,$month,$day,$year));
echo("<tr>
<td align=\"left\">$date1</td><td align=\"left\">$live_city, $live_venue</td><td align=\"center\">$live_team</td><td align=\"center\"><input type=\"radio\" name=\"live_id_$live_id\" value=\"1\" style=\"border: none\"></td><td align=\"center\"><input type=\"radio\" name=\"live_id_$live_id\" value=\"2\" style=\"border: none\"></td><td align=\"center\"><input type=\"radio\" name=\"live_id_$live_id\" value=\"3\" style=\"border: none\"></td><td align=\"center\"><input type=\"radio\" name=\"live_id_$live_id\" value=\"4\" style=\"border: none\" checked></td>
</tr>");
}
