?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board

PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


C# Help

?
?Two Table Query
Author:??(---.nyc.rr.com)
Date:???01-08-04 05:50

Here is a visual example of what I am trying to do with my query....
http://www.djgallagher.com/query.gif

I've tried...

SELECT
news_id,
news_title,
news_date,
DATE_FORMAT(news_date, '%M %e %Y') as newsdate
FROM
mjf_newsarticles
ORDER BY
news_date ASC
LIMIT 0,5
UNION
SELECT
eventid,
eventname,
eventdate,
DATE_FORMAT(eventdate, '%M %e, %Y') as event_date
FROM
mjf_events
ORDER BY
eventdate ASC
LIMIT 0,5

But this isn't working...

?Topics Author? Date
?Two Table Query??new
Jabbamonkey 01-08-04 05:50?
?Re: Two Table Query??new
bastien 01-08-04 11:55?
?Re: Two Table Query??new
Jabbamonkey 01-08-04 12:06?
?Re: Two Table Query??new
bastien 01-08-04 15:20?
?Re: Two Table Query??new
Jabbamonkey 01-08-04 15:30?
?Re: Two Table Query??new
bastien 01-08-04 15:37?
?Re: Two Table Query??new
Jabbamonkey 01-08-04 16:09?
?Re: Two Table Query??new
bastien 01-08-04 20:15?
?Re: Two Table Query??new
Jabbamonkey 01-09-04 06:49?
?Re: Two Table Query??new
bastien 01-09-04 07:25?
Go to Top??|??Go to Topic??|??Flat View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
??wrote: > > Here is a visual example of what I am trying to do with my > query.... > http://www.djgallagher.com/query.gif > > I've tried... > > SELECT > news_id, > news_title, > news_date, > DATE_FORMAT(news_date, '%M %e %Y') as newsdate > FROM > mjf_newsarticles > ORDER BY > news_date ASC > LIMIT 0,5 > UNION > SELECT > eventid, > eventname, > eventdate, > DATE_FORMAT(eventdate, '%M %e, %Y') as event_date > FROM > mjf_events > ORDER BY > eventdate ASC > LIMIT 0,5 > > But this isn't working... ">??

Provided By
Phorum