Brain isnt working today...
$query = "SELECT count(*) AS nts FROM p";
$result = @mysql_query($query) or die ("mysql error: " . mysql_error());
$row = mysql_fetch_array($result);
$num_total_stations = $row["num_total_stations"];
$query = "SELECT t.*, count(p.sid) AS num_stat FROM status t LEFT JOIN p ON t.sid = p.sid GROUP BY t.sid";
$result = @mysql_query($query) or die ("mysql error: " . mysql_error());
print '<div><ul style="list-style-type:none;">';
for($row_count=0; $row = mysql_fetch_array($result); $row_count++) {
print '<li><div class="text">';
print "$row[status_name]";
print '</div></li>';
}
print '</ul></div>';
The query returns 12 results and I want to divide them into 3 divs with 4 results each... so how do I go about this? I either get an endless loop or everything in 1 div...
Thanks!
