a "control break" code it what your after
basically:
$old_val = "";
for (??; ??; ??)
{
$new_val = $place; // however you get the next entry's place
if ($new_val != $old_val)
{
$old_val = $new_val;
echo $new_val; // obviously formatted...
}
echo $name;
}
now fill in the blanks
Martin T
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Group by Howto
I have a database with 2 colums in it
-------------|------|
Place of work| Name |
-------------|------|
I want to print out a listing of peoples name by the place their work from
a php script
so
Place 1
person a
person b
person c
Place 2
person d
Place 3
person F
person G
This has to be easy to do can anyone point me in the right direction...I
understand I have to use the group by clause I just don't know how to get
PHP to sort it
Michael
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
