joint 2 queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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&#39;ve always wanted before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/

[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux