Re: SQL Query - Using variable from another SQL Query
| From: | tg-php at gryffyndevelopment dot com | Date: | Mon, 12 Feb 2007 16:31:31 +0000 |
| Subject: | Re: SQL Query - Using variable from another SQL Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43063@lists.php.net to get a copy of this message | ||
Try this as your SQL. It should give you all the results, then you can use PHP to sort it all out.
SELECT * FROM egw_cal WHERE cal_category='501' and cal_id in (SELECT cal_id FROM
egw_cal_dates where cal_start > $tstamp)
-TG
= = = Original message = = =
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);
$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] - $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...";
?>
___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.