What is the code for the inner query? Hard to advise you based on the small
bit of code you posted.
Are you using the same $result var for both queries? If so, that's why. Just
run two separate queries stored in to different result vars. I do this all
the time with no problems.
> From: [EMAIL PROTECTED] (Cf High)
> Newsgroups: php.general
> Date: Mon, 3 Mar 2003 16:45:52 -0800
> To: [EMAIL PROTECTED]
> Subject: Run db query with db query?
>
> 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
