[nycphp-talk] Newbie question: extract categories and display once
Glasgow West End
james.byrne2 at ntlworld.com
Thu Feb 13 09:53:47 EST 2003
Hmm, nice and simple.
Thanks Jim.
>
> From: "Jim Hendricks" <jim at bizcomputinginc.com>
> Date: 2003/02/13 Thu PM 01:12:53 GMT
> To: NYPHP Talk <talk at nyphp.org>
> Subject: Re: [nycphp-talk] Newbie question: extract
categories and display once
>
> A down and dirty way would be to define a variable
which is initially blank
> or null.
>
> At the top of your loop which you use to iterate through
the articles check
> to see if the category associated with the article is the
same as that
> stored in the variable. If it is different, pump out the
category info and
> set the variable to the category you just output. If it is
the same, skip
> outputting the category info.
>
> This assumes that your query which obtains the data
brings it back in
> category order.
>
> Jim
>
> ----- Original Message -----
> From: "QuicknEasyImage"
<jim at quickneasyimage.com>
> To: "NYPHP Talk" <talk at nyphp.org>
> Sent: Thursday, February 13, 2003 3:06 AM
> Subject: [nycphp-talk] Newbie question: extract
categories and display once
>
>
> > Hi,
> >
> > I am creating a MSQL database of articles, all
labeled by categories -
> i.e.
> > marketing, copywriting, ecommerce and so on. I
want to display the links
> to
> > these articles on a web page, sorted by category. I
only want to display
> > the category name on the web page once - and
underneath that, all the
> > articles that fall into that category, then the next
category name and all
> > the articles under that that fall into that category, and
so on.
> >
> > I can extract and display the links to the articles
easy enough, but can't
> > think how to make sure that the category name
prints only once - at the
> top
> > of category list. Any ideas would be appreciated.
> >
> > Thanks,
> > Jim
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> --- Unsubscribe at http://nyphp.org/list/ ---
>
>
>
More information about the talk
mailing list