You could always use the % operand
<snip>
$cols_wanted = 2;
if(($faculty_found % $cols_wanted) == 0) {
// Then do a <TR>
echo '<tr>';
} else {
// Then it's the first column, and don't end the row
}
</snip>
Advertising
This also simplifies it so that you can decide to use three, four or five
columns, just by changing the $cols_wanted variable
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -----Original Message-----
> From: Becoming Digital [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 5:01 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Two-column display of data, second method
>
>
> Nice job. There's a fair bit of room for optimization, but
> unless your data
> sets are very large, it's probably not necessary. However,
> if you're compulsive
> (as I tend to be), you'll optimize every bit of code to the
> best of your
> abilities. And yes, I know I'm crazy. ;P
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> ----- Original Message -----
> From: "David Shugarts" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, 19 June, 2003 17:43
> Subject: [PHP-DB] Two-column display of data, second method
>
>
> 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
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
