Re: Interesting Problem

Hi Yoed, > 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 from your table definition i didn't see any relation between those two tables, so most probably it doesnt make sense to make a "join" operation. just do it in 2 query, one for each table. -- Jimmy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ When you have a hammer, you tend to treat everything as if it were a nail.