* Yoed Anis
> Hi... I have an interesting problem I don't know which way to
> solve. I tried posting this on the PHP site (since I'm coding
> with PHP and mysql) but they said I might want to try my odds
> here.. since they suggested I go with the mysql solution, but
> I'm clueless where to start. So I'll shoot it out to you guys
> and see what you might offer.
>
> I have two databases, say X, and Y:
>
> CREATE TABLE X(
> Id int(11) NOT NULL auto_increment,
> Dep_Date date,
> Return_Date date,
> Cat1_Status varchar(100),
> Cat2_Status varchar(100),
> Cat3_Status varchar(100),
> Cat4_Status varchar(100),
> PRIMARY KEY (Id));
>
> CREATE TABLE Y(
> Id int(11) NOT NULL auto_increment,
> Dep_Date date,
> Return_Date date,
> A_Status varchar(100),
> B_Status varchar(100),
> C_Status varchar(100),
> D_Status varchar(100),
> E_Status varchar(100),
> PRIMARY KEY (Id));
>
> Now what I am trying to do is get it to display on one page one listing in
> Chronoligical order based on the Dep_Date from BOTH of these
> tables. Trying something simple like
> mysql_query("SELECT Id, Dep_Date, Return_DateFROM X,Y WHERE Dep_Date LIKE
> '%$SelectDate%' OR Return_Date LIKE '%$SelectDate%' ORDER BY Dep_Date");
> Will give you a ton of errors, and I'm not very fimilar with JOIN and SQL
> and how that works. My idea was to create two querys, but the results in
> somesort of array, and then order the array by date... I was wondering
> though if this is a good efficient way or if you guys have any better
> suggestions as to what I should do.
You can do it using a temporary table and three separate sql statements:
CREATE TEMPORARY TABLE t1
SELECT Id, Dep_Date, Return_date
FROM X
WHERE
Dep_Date LIKE '%$SelectDate%' OR
Return_Date LIKE '%$SelectDate%';
INSERT INTO t1
SELECT Id, Dep_Date, Return_date
FROM Y
WHERE
Dep_Date LIKE '%$SelectDate%' OR
Return_Date LIKE '%$SelectDate%';
SELECT * FROM t1 ORDER BY Dep_Date;
(The temporary table is automatically deleted when the connection is
closed.)
--
Roger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
