* 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