Wednesday 29 October 2014

two different query to assign in a single variable to fetch data

<?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);

?>

No comments:

Post a Comment