nesting queries
| From: | Mike Teigen | Date: | Fri, 11 Feb 2000 09:13:38 +0000 |
| Subject: | nesting queries | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-10092@lists.php.net to get a copy of this message | ||
Does anyone know if you can nest queries?? This is what im trying to do...
MYSQL_CONNECT($hostname,$username) OR DIE("Unable to connect to database");
@mysql_select_db("$dbName") or die("Unable to select database");
$tncQuery = "SELECT distinct DATE_FORMAT(issueDate,'%M %Y') as issueDate2
from TNC
where showw = 1
order by issueDate desc"
;
$result = MYSQL_QUERY($tncQuery);
$tncNumber = MYSQL_NUMROWS($result);
$i=0;
WHILE ($i < $tncNumber):
$tncQueryDate = mysql_result($result,$i,"issueDate2");
$issueQuery = "SELECT *
from TNC
where showw = 1
and issueDate = $tncQueryDate
order by entryID"
;
$issueResult = MYSQL_QUERY($issueQuery);
$issueDate = mysql_result($result,0,"issueDate");
$issueLead = mysql_result($result,0,"issueLead");
echo "$issueDate, $issueLead";
$i++;
endwhile;?>
but i get an error everytime i set teh $issueDate and $issueLEad variables in teh second query!!!
Driving me nuts please help!!!!!!!!