May be it can solve your problem.
= mysql_query("SELECT * FROM multipleevent WHERE typeOfEvent ='$event' and exists (SELECT * FROM project WHERE summery LIKE'%$keywords%' OR country LIKE'%$keywords%' OR Projectstatus LIKE '%$keywords%' OR city LIKE'%$keywords%' OR title LIKE '%$keywords%' OR CC_roles LIKE '%$keywords%' AND city LIKE '%$city%' AND country LIKE '%".$country."%' AND category LIKE '%".$category."%' AND startYear >=$startYear AND endYear <= $endYear AND startMonth >=$smonth AND endMonth <=$emonth"));
________________________________
From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of tap haran
Sent: 22 September 2009 16:05
To: php-objects@xxxxxxxxxxxxxxx
Subject: joint 2 queries
Hi guys
i have an issue,i want to joint 1 search and 1 select queries,how to do that.plz help
1.
$data = mysql_query("SELECT * FROM project WHERE summery LIKE'%$keywords%' OR country LIKE'%$keywords%' OR Projectstatus LIKE '%$keywords%' OR city LIKE'%$keywords%' OR title LIKE '%$keywords%' OR CC_roles LIKE '%$keywords%' AND city LIKE '%$city%' AND country LIKE '%".$country."%' AND category LIKE '%".$category."%' AND startYear >=$startYear AND endYear <= $endYear AND startMonth >=$smonth AND endMonth <=$emonth");
2.
$result = mysql_query("SELECT * FROM multipleevent WHERE typeOfEvent ='$event' "
Get your new Email address!
Grab the Email name you've always wanted before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
