| Micah Stevens 2007-02-12, 6:59 pm |
| This is a join - Read up on them, they're very useful and don't require
the overhead of a sub-query.
SELECT egw_cal.* FROM egw_cal_dates
LEFT JOIN egw_cal using (cal_id)
where egw_cal_dates.cal_start > $tstamp
AND egw_cal.cal_category = '501'
-Micah
On 02/12/2007 08:14 AM, 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);
>
> $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...";
>
> }
>
> ?>
>
>
>
|