[thelist] help w/design of SQL query

Tom Dell'Aringa pixelmech at yahoo.com
Fri Nov 15 11:28:00 CST 2002


--- rudy <r937 at interlog.com> wrote:

> you need to add     ORDER BY category, item

added that.

However I still get the category listing each time (its just ordered
by cat now). I only want the category listed once with its associated
items under each.

> you have a wee error, in that you're printing price when you
> haven't
> retrieved it in the query, but you would have found that yourself,
> right?

Yes, and I used the previous posters new code..

> also, ordinarily i would just let this slide, tom, but i know
> you're the
> type of person to care about stuff like this, so i thought i'd
> point it
> out...
>
> that's not well-formed html you're echoing there
>
> the items should be inside a <p>..</p> block

Oh absolutely - I'm just trying to get the thing to work first!

Tom

=====
var me = tom.pixelmech.webDeveloper();

http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



More information about the thelist mailing list