Hey all.
Got a problem here:
1) I have a page that queries our db for info
2) Based on the # of rows returned I loop through to create a set of
formfields for each customer
3) Within this loop I run another query to retrieve option elements for
a particular category
The problem is that the inner query is overwriting the result resource for
the outer query. So:
while ($q = mysql_fetch_row($result)) {
build form tables for each client and run inner query
html stuff
/* Calls db query to populate particular option category */
write_select_options($tables,$form_fields,$where_clause);
}
What's the conventional method for running queries within queries?
Any leads most appreciated,
--Noah
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
