Re: MySQL/PHP how to put the results of one query in another query

This is what I use when needing to do this: 1. Put all the values you want to search for in an array $vals (loop around the first result) 2. $query = " select count(Nome) from Aeromodelistas where year(AnoQuota)=2005 and Sexo='Masculino' and Distrito IN ".sqlIn($vals) ; function sqlIn($vals, $quote="'") { if (!is_array($vals)) $vals = array($vals); $s = '('; $c = ''; foreach ($vals as $val) {

       $s .= $c.$quote.addslashes($val).$quote;
       $c = ',';

} return $s.')'; } Pedro Quaresma de Almeida wrote:

Hi I have two MySQL databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the following query SELECT CódigoPostal FROM Aeromodelistas WHERE CódigoPostal IN (SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO WHERE codigopostal.LOCART.DD=codigopostal.DISTRITO.DD AND codigopostal.DISTRITO.DESIG='Coimbra'); This query is not working, and I do not know why. If I try the two queries individualy they work, togheter they don't!? But the question I want to put to the members of this list is the following. Is it possible to do the following? // first do the subquery $sql_CP4s = "select distinct(CP4) from codigopostal.LOCART,codigopostal.DISTRITO where codigopostal.LOCART.DD=codigopostal.DISTRITO.DD and codigopostal.DISTRITO.DESIG='$nomeDistrito'"; $resultado_CP4s = mysql_query($sql_CP4s,$ligacao); $linha_CP4s = mysql_fetch_assoc($resultado_CP4s); // then use it's results in the main query $sql_Aero_Dist_Masc = "select count(Nome) from Aeromodelistas where year(AnoQuota)=2005 and Sexo='Masculino' and Distrito IN $linha_CP4s"; How can we include the results (not just one) of one query in another query? Is it possible?