Tim McDonough writes:
>The solution I presently have does a query for the first criteria.
>Then, I loop through the results of that query and do another query
>for each returned row. This produces the desired results but requires
>a lot of queries, i.e.-- if the first query returns 1000 customer
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
> two criteria whether
* Tim McDonough
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
>
CTED]
Sent: 4/9/04 8:20 AM
Subject: Better Solution than Multiple Queries?
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to di
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or not the
ror message
> from MySQL on the second line, which is OK. My question is: Is there a
> better solution than put a line like
>
> If (mysql_num_rows($result)>0) ...
>
> Could I solve it differently?
>
> Thanks
> Karel
$query=("select distinct(publisher) from
ine, which is OK. My question is: Is there a
better solution than put a line like
If (mysql_num_rows($result)>0) ...
Could I solve it differently?
Thanks
Karel
-
Before posting, please check:
http://www.mysql.com/m
ine, which is OK. My question is: Is there a
better solution than put a line like
If (mysql_num_rows($result)>0) ...
Could I solve it differently?
Thanks
Karel
-
Before posting, please check:
http://www.mysql.com/m
