Re: SQL Query - Using variable from another SQL Query

Matthew Ferry wrote:

Hello Everyone.... Got a simple / stupid question. Worked on this all night. I'm over looking something very basic here. The query "event_time" brings back the calendar id for each event that is pending in the future. ie.... 12, 13, 14, 26 (There could be 100 of them out there) The second query "events" needs to meet both reqirements. 1 - cal_category='501' 2 - cal_id= a number from the "event_time" query I think i need to do a loop inside of a loop Thanks... Matt Here is my code: <?php $todays_year = date("Y"); $todays_month = date("m"); $todays_day = date("d"); $tstamp = mktime(0, 0, 0, $todays_month, $todays_day, $todays_year); $event_time = mysql_query("SELECT cal_id FROM egw_cal_dates where cal_start > $tstamp", $db); This returns a mysql result set...not the actual data...

search php.net for the function mysql_fetch_array or others to actually *get* the data. (Some good examples there will help you sort this out!)

$events = mysql_query("SELECT * FROM egw_cal WHERE cal_category='501' and cal_id='$event_time'\n", $db); if ($event = mysql_fetch_array($events)) { echo "<center>\n"; echo "<HR>\n"; do { echo "<B><Font Size='10'>$event[cal_title]&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;$event[cal_location]</B></Font>\n"; echo "<BR>\n"; echo "$event[cal_description]"; echo "<BR>\n"; echo "<HR>\n"; } while ($event = mysql_fetch_array($events)); } else { echo "No Public Events Are Currently Scheduled..."; } ?>