[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