Posted by gerg on 12/22/05 08:58

This is beyond my scope of knowledge at this point. I've got two
databases, one with "user info", the other with "events".

I'm working on a calendar that at this point selects all user posted
"events" from the events db.

The query is this:

$sql="SELECT * FROM `calendar` WHERE `month`=\"$month\" AND
`year`=\"$year\" ORDER BY `day` asc";

This works great.

Now I want to add into this query, a selection of the "user info"
birthdates and mix them in with the results of the query.

So if I had two events, Jan 1 and Jan 3, and a birthday on Jan 2, the
results would be:

Jan 1. Event
Jan 2. Birthday
Jan 3. Event

How could I modify the sql query below to accomplish this?

$sql="SELECT * FROM `calendar` WHERE `month`=\"$month\" AND
`year`=\"$year\" ORDER BY `day` asc";

Thanks in advance.

Greg

[Back to original message]