Php dates and recordsets

Here i am again with another little quandry. I have two recordsets on the page with events in repeat regions, I am trying to filter them by date the past shows to show ones date past and upcoming to show where date > greater than, I set the recorsets in dreamwaever and variables to the date and test all seem s well. I go to wiew page I get this error:
Fatal error: Can't use function return value in write context in C:\wamp\www\Crossroads\FeaturedExhibits.php on line 37
So I did a bit of research and supposable to do with the syntax on the isset function, I mod it around a bit and that error goes away but I get major warning in haed of my page and only one of my recorsets show up. I have data for both the past and future shows.
I'm sure I just struggling with this date() stuff and php cause I'ts new to me and I cannot for the life of me get it correct.
I am including to page If you would'nt mind taking a look?

Tracy

I also tried taking the variables out and using this code in the recordsets:

SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start FROM featured_shows, calendar_event WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') >= DATE_FORMAT(now(),'%Y-%m-%d')

on one and

SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start FROM featured_shows, calendar_event WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') <= DATE_FORMAT(now(),'%Y-%m-%d')

on the other then I get no errors but the where statement is'nt working I am attaching the page as it now sits. and here is a link to view what it's doing live:

FeaturedExhibits.php

Thanks!

Tracy

to help troubleshoot this, I'll need some additional info.

on your page, change the code for displaying the past shows:

<h2>Past shows</h2>
              <?php do { ?>
                <table width="100%" border="0">
                  <tr>
                    <td><a href="FeaturedExhibitsDetail.php?event_id=<?php echo $row_rsFeatListpast['event_id']; ?>"><?php echo $row_rsFeatListpast['feat_title']; ?></a></td>
                  </tr>
              </table>
                <?php } while ($row_rsFeatListpast = mysql_fetch_assoc($rsFeatListpast)); ?>

to:

<h2>Past shows: <?php echo("SQL: ".$query_rsFeatListpast); ?></h2>
              <?php do { ?>
                <table width="100%" border="0">
                  <tr>
                    <td><a href="FeaturedExhibitsDetail.php?event_id=<?php echo $row_rsFeatListpast['event_id']; ?>"><?php echo $row_rsFeatListpast['feat_title']; ?>||<?php echo $row_rsFeatListpast['calendar_event.date_start']; ?></a>calendar_event.date_start</td>
                  </tr>
              </table>
                <?php } while ($row_rsFeatListpast = mysql_fetch_assoc($rsFeatListpast)); ?>

and the code for showing upcoming shows:

<h2>upcoming shows</h2>
              <?php do { ?>
              <table width="100%" border="0">
                  <tr>
                    <td><a href="FeaturedExhibitsDetail.php?event_id=<?php echo $row_rsFeatListup['event_id']; ?>"><?php echo $row_rsFeatListup['feat_title']; ?></a></td>
                  </tr>
              </table>
                <?php } while ($row_rsFeatListup = mysql_fetch_assoc($rsFeatListup)); ?>

to:

<h2>upcoming shows: <?php echo("SQL: ".$query_rsFeatListup); ?></h2>
              <?php do { ?>
              <table width="100%" border="0">
                  <tr>
                    <td><a href="FeaturedExhibitsDetail.php?event_id=<?php echo $row_rsFeatListup['event_id']; ?>"><?php echo $row_rsFeatListup['feat_title']; ?>||<?php echo $row_rsFeatListup['calendar_event.date_start']; ?></a></td>
                  </tr>
              </table>
                <?php } while ($row_rsFeatListup = mysql_fetch_assoc($rsFeatListup)); ?>

this will show the dates for the shows and the SQL that is executed at run time for the recordsets.

Cool Jason!
The page is now on the server!

Tracy

what is the structure of the FEATURED_SHOWS and CALENDAR_EVENT tables?

I think you need to be using a join query:
sql_join.asp

the calendar event table has a primary key column called "id" in the featured shows table I have a column event_id which I'm trying to relate to that.

ok, so the select / from portion of your query:

SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start 
FROM featured_shows, calendar_event

needs to be changed to use inner join:

SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start 
FROM featured_shows
INNER JOIN calendar_event
ON featured_shows.event_id = calendar_event.id

I probably would'nt even need the date_format option like this then:
SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start FROM featured_shows, calendar_event WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') >= DATE_FORMAT(now(),'%Y-%m-%d')

If I was to use a join could I just use Date()?

I'm just not sure How I would join those?

You beat me to the post I'll try what you suggest and get back to you.

Tracy

no, you would still need the where clause at the end of the SELECT .. FROM ... INNER JOIN... ON.. statement i provided. so the full sql statement would be:

SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start 
FROM featured_shows
INNER JOIN calendar_event
ON featured_shows.event_id = calendar_event.id
WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') >= DATE_FORMAT(now(),'%Y-%m-%d')

That did the trick thanks Jason!
Look like I'm gonna have to rewrite a few of my query's this way now, thanks for getting me pointed in the right direction!

Tracy