Hi folks
I am trying to print out a table of elements in alphabetical order. I have
an SQL query which sorts out the data in order and am using 'while ($info
=(mysql_fetch_row...etc)) to read the data array. I need it to echo out a
table with all the A's first, then a blank line, then all the
Hello,
This is a reply to an e-mail that you wrote on Tue, 22 Jul 2003 at
17:40, lines prefixed by '' were originally written by you.
I need it to echo
out a
table with all the A's first, then a blank line, then all the B's,
a
blank
line and so on. I could write 26 different queries, one for
I need it to echo out a table with all the A's first, then a blank line,
then all the B's, a blank line and so on. I could write 26 different
queries, one for each letter of the alphabet, but surely there is a tidier
way.
Do a query, sorting by the field you need alphabetized. Then do this (and
/* UNTESTED - and prolly could be more efficient */
$c = $d = '';
natsort($info);
foreach ( $info as $i ) {
$d = substr($i, 0, 1);
if ( $d != $c )
echo \n;
echo $i;
$c = $d;
}
On Tuesday 22 July 2003 09:40 am, Don Mc Nair wrote:
Hi folks
I am
4 matches
Mail list logo