Two Table Query - "WHERE" Clause Difficulty

[PHPRookie]

One of my query works, the top one. The bottom query does not work.

The only difference is the "WHERE" portion of the query.

Any help would be appreciated

This is the query that works:

while ($startdate<=$enddate)
{
$sql1="SELECT
event.eventtitle,
event.eventtype,
event.venuename,
event.description1,
event.description2,
event.description3,
event.description4,
event.additionalinfo,
event.dayone,
event.dayonedate,
event.dayonetime1,
event.dayoneprice1,
event.dayonetime2,
event.dayoneprice2,
event.dayonetime3,
event.dayoneprice3,
venue.venuetype,
venue.address1,
venue.address2,
venue.addresssupplement,
venue.phone,
venue.hours,
venue.borough,
venue.directions

			FROM event, venue

			WHERE 

			event.venuename = venue.venuename";

			$result1 = mysql_query($sql1)
			or die ("Couldn't execute query.");

This is the query that does not work:

while ($startdate<=$enddate)
{
$sql1="SELECT
event.eventtitle,
event.eventtype,
event.venuename,
event.description1,
event.description2,
event.description3,
event.description4,
event.additionalinfo,
event.dayone,
event.dayonedate,
event.dayonetime1,
event.dayoneprice1,
event.dayonetime2,
event.dayoneprice2,
event.dayonetime3,
event.dayoneprice3,
venue.venuetype,
venue.address1,
venue.address2,
venue.addresssupplement,
venue.phone,
venue.hours,
venue.borough,
venue.directions

			FROM event, venue

			WHERE 

			$startdate = event.dayonedate AND event.venuename = venue.venuename";

			$result1 = mysql_query($sql1)
			or die ("Couldn't execute query.");

[Gargouil]

Hi

Have you tried with mysql_error() ?

if you have an error in your query you will know it

after executing mysql_query(...);
add this line:

echo mysql_error();

you query seems good at one thing...

if $startdate is a text value you should put it in "" like this

...

\"$startdate\" = event.dayonedate AND event.venuename = venue.venuename";