Page 1 of 1

Query Question

Posted: Thu Feb 14, 2008 2:32 pm
by QbertsBrother
so i have a question about some things when i make a query.

i am doing something like this.

i make a query. then i do a while loop to output some data from the database. inside the while loop i make another query based on a result from my first query. and i may do that a couple of times.

now it works great for what i need to do my main question is. is it bad practice to do something like that?

Re: Query Question

Posted: Thu Feb 14, 2008 2:35 pm
by Christopher
Look into doing JOINs so you only need to do one query. Search and you will find lots of information on the web.