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.
Thanks for your time and help,
Yoed
---------------------------------------------------------------------
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
