"; // uncomment to troubleshoot db problems
$numrows = mysql_num_rows($result);
$limit = floor(($numrows/2));
//echo"$limit <-- limit
";
$over = $numrows % 2;
//echo"$over < over
";
$limit2 = $limit + $over;
$rowCount = 0;
$offset = 0;
$query = "SELECT * FROM trivia_quizzes ORDER BY categoryName LIMIT $offset, $limit";
$result = mysql_query($query);
//echo mysql_errno().": ".mysql_error()." 2
"; // uncomment to troubleshoot db problems
//echo" | ";
while($r = mysql_fetch_array($result))
{
$id = $r["id"];
$name = $r["name"];
echo"$name
";
}
echo" |
";
$query = "SELECT * FROM trivia_quizzes ORDER BY categoryName LIMIT $limit, $limit2";
$result = mysql_query($query);
while($r = mysql_fetch_array($result))
{
$id = $r["id"];
$name = $r["name"];
echo"$name
";
}
echo"";
?>
|
