i need some help with extracting data from mysql
| From: | Sandeep Hundal | Date: | Thu, 10 May 2001 10:32:46 +0000 |
| Subject: | i need some help with extracting data from mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-52255@lists.php.net to get a copy of this message | ||
hi all,
i've got a simple problem, yet it doesn't work, so i hope someone can
help me out here.
i've got a table with id, group, and name. each group has many names
ofcourse.
now i need to output the data like :
> group1
>name1
>name2
>name3
>group2
>name4
>name5
>group3
>name6
etc........
my query is "SELECT group, name FROM $tablename WHERE approved='yes'
GROUP BY folder ORDER BY folder;
yet the ouput can't seem to handle more than 1 name per group.
any ideas?? thanks in advance!
/sunny
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie