Hi !
It's directly possible only if there is a relationship between the tables,
that is, If one table has a reference for the id of the other one.
Otherwise, you have to build a code in php for extracting each element of
the queries and getting the desired result.
2009/9/22 tap haran <tapharan@xxxxxxxxx>
>
>
> 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]
>
>
>
--
Altamiro Teixeira de Souza
[Non-text portions of this message have been removed]
