[thelist] SQL query and filtering output with PHP

John Corry webshot at neoncowboy.com
Mon Jun 4 19:21:17 CDT 2001

I guess because I was trying to execute only one query...since that's all
that was necessary to get everything...I did it the way you suggested, it
works...but its kind of ugly, lots of repeating code (with just one variable
changed per instance).

So now, I have 3 queries...one for each category of work...

and I'm done!


> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Anthony Baratta
> Sent: Monday, June 04, 2001 1:58 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] SQL query and filtering output with PHP
> are you sure you want a while statement? wouldn't an if work better?
> Why not filter at the SQL level and not worry about it.
> select * from paintings where category = 'oil'
> ----
> Anthony Baratta
> President
> Keyboard Jockeys
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list