When I went looking for a script that would give me a two-column layout that
would list my faculty members in two roughly equal columns, alphabetized
down the first column and then the second, I did not find such a script.
[There was indeed a "two-column" script, but it fed the data row-by-row.]
I wrote this one and am glad to share it. The math statements could surely
be condensed, but I was using them to confirm the results. This script
either creates two equal columns if the total number of items is even, or it
makes the first column the longer if the total number of items is odd.
--Dave Shugarts
<?php
/* ******* Now selects the Faculty names ****** */
$sql ="SELECT FirstName, Middle, LastName
FROM $table_name
ORDER BY LastName, FirstName";
/* ****** Now passes the result of the search ****** */
$faculty_result = @mysql_query($sql, $connection) or die("Error #".
mysql_errno() . ": " . mysql_error());
$faculty_found = @mysql_num_rows($faculty_result);
$faculty_half = $faculty_found / 2;
$faculty_round = round($faculty_found / 2);
$faculty_remain = $faculty_found - $faculty_round;
echo "<table border=0>
<tr><td colspan=2 align=center><b>
Two-Column header
</b><br></td></tr>
<tr><td width=49%>\n";
for ($rownum = 1; $rownum <= $faculty_round; $rownum++)
{
$row = mysql_fetch_array($faculty_result);
$FirstName=$row['FirstName'];
$Middle=$row['Middle'];
$LastName=$row['LastName'];
$faculty_block = "
<font class=facultydoc>
$FirstName $Middle $LastName
</font>
<br>
";
echo "$faculty_block<br>";
}
echo "</td><td>\n";
for ($rownum = 1; $rownum <= $faculty_remain; $rownum++)
{
$row = mysql_fetch_array($faculty_result);
$FirstName=$row['FirstName'];
$Middle=$row['Middle'];
$LastName=$row['LastName'];
$faculty_block = "
<font class=facultydoc>
$FirstName $Middle $LastName
</font>
<br>
";
echo "$faculty_block<br>";
}
echo "</td></tr><br></table>";
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
