RE: [PHP-DB] Two-column display of data, second method
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
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
trtd colspan=2 align=centerb
Two-Column header
/bbr/td/tr
trtd 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_blockbr;
}
echo /tdtd\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_blockbr;
}
echo /td/trbr/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
Re: [PHP-DB] Two-column display of data, second method
That was actually my primary point of optimization. Unfortunately, I've been
feeling a bit lazy, so I didn't bother going into things. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, 20 June, 2003 10:39
Subject: RE: [PHP-DB] Two-column display of data, second method
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
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
trtd colspan=2 align=centerb
Two-Column header
/bbr/td/tr
trtd 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_blockbr;
}
echo /tdtd\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_blockbr;
}
echo /td/trbr/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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[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
trtd colspan=2 align=centerb
Two-Column header
/bbr/td/tr
trtd 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_blockbr;
}
echo /tdtd\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_blockbr;
}
echo /td/trbr/table;
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
