Re: i need some help with extracting data from mysql
| From: | Steve Werby | Date: | Thu, 10 May 2001 16:03:47 +0000 |
| Subject: | Re: i need some help with extracting data from mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52310@lists.php.net to get a copy of this message | ||
"Sandeep Hundal" <sandeep_wde@yahoo.com> wrote:
> 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.
Are these *all* of the field names?
> 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;
You lost me. Where is the field "folder"? Can you output the results of
"DESCRIBE tablename" for the table and a few records?
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/