Hi there,
I have a user table which contains province and country.
Another table named provinces contains this fields to and also the name of
the province.
Now I am trying to find out the provinces user are registered coming from a
special country. Unfortunatelly this statement underneath:
$stmt= "
SELECT DISTINCT c.province, c.province_id
from $DB2.$geo_T2 c, $DB.$T5 U
WHERE U.province_id = c.province_id AND c.country_code = '$country'
";
returns to much provinces. Thats because it is selecting all province_ids
from the user table and not only the ones with the proper country.
I guess there has to be a subselect ore something like this.
Maybe one of you guys have an idea.
Cheers Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
