Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_GET['keywords'])) {
- $queryx=str_replace("+"," ",$_GET['keywords']);
- {
- $data=$database->query("
- SELECT
- COUNT(*) AS counted,
- listing_property.ad_title,
- listing_autos.ad_title,
- listing_classified.ad_title,
- listing_deals.ad_title,
- listing_jobs.ad_title,
- listing_services.ad_title,
- listing_leads.ad_title,
- subpages.shortname,
- pages.shortname
- FROM
- (listing_autos, listing_property, listing_classified, listing_deals, listing_jobs, listing_services, listing_leads)
- INNER JOIN
- subpages ON (listing_autos.formsubid = subpages.id
- AND listing_property.formsubid = subpages.id
- AND listing_deals.formsubid = subpages.id
- AND listing_classified.formsubid = subpages.id
- AND listing_deals.formsubid = subpages.id
- AND listing_jobs.formsubid = subpages.id
- AND listing_services.formsubid = subpages.id)
- INNER JOIN
- pages ON (subpages.hd_id = pages.id)
- WHERE
- LOWER(listing_autos.ad_title) LIKE '%$queryx%'
- OR LOWER(listing_property.ad_title) LIKE '%$queryx%'
- OR LOWER(listing_classified.ad_title) LIKE '%$queryx%'
- OR LOWER(listing_deals.ad_title) LIKE '%$queryx%'
- OR LOWER(listing_jobs.ad_title) LIKE '%$queryx%'
- GROUP BY listing_property.ad_title, listing_autos.ad_title, listing_classified.ad_title, listing_jobs.ad_title, listing_services.ad_title, listing_deals.ad_title, listing_leads.ad_title, subpages.shortname, pages.shortname
- ");
- if($rs=mysqli_num_rows($data)!=0){
- while($tag=mysqli_fetch_array($data))
- {
- $maintag=$tag['shortname'];
- $subtag=$tag['subsname'];
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement