<?php
$query = sprintf("SELECT * FROM `registered_profile` WHERE (`industry`='". $_POST['industry']."' && `subindustry`='".$_POST['subindustry']."' && `city`='".$_POST['city']."' && `status`='Y') || `subindustry`='".$_GET['id']."' || `state`='".$_GET['id1']."' || `city`='".$_GET['id2']."'");
if(isset($_POST['search']))
{
$query = sprintf("SELECT * FROM `registered_profile` WHERE `company_address` REGEXP '" . mysql_real_escape_string($_POST['search']) . "'");
}
$row = mysql_query($query);
?>
$query = sprintf("SELECT * FROM `registered_profile` WHERE (`industry`='". $_POST['industry']."' && `subindustry`='".$_POST['subindustry']."' && `city`='".$_POST['city']."' && `status`='Y') || `subindustry`='".$_GET['id']."' || `state`='".$_GET['id1']."' || `city`='".$_GET['id2']."'");
if(isset($_POST['search']))
{
$query = sprintf("SELECT * FROM `registered_profile` WHERE `company_address` REGEXP '" . mysql_real_escape_string($_POST['search']) . "'");
}
$row = mysql_query($query);
?>
No comments:
Post a Comment