$id = isset($_GET['id']) ? $_GET['id'] : '' ;
$option = '';
$option.= ($id=='') ? '' : " and a.qID = '$id%' " ;
$sql="select a.*,f.qName as country,g.qName as prov, ".
"b.qPath,b.qFilename,c.qName as career,d.qName as income, ".
"e.qName as marriage,f.qId as country_id ".
"from qUser a Left join qPhotos b on a.qID=b.qUserID and b.qMain=1 ".
"left join qCareer c on a.qCareer = c.qID ".
"LEFT JOIN qIncome d on a.qSalary = d.qID ".
"LEFT JOIN qMarriage e on a.qMarriageid = e.qID ".
"LEFT JOIN qCountry f on a.qCountryid = f.qID ".
"LEFT JOIN qProvince g on a.qProvinceid = g.qID ".
"WHERE a.qStatus=1 and a.qVerified=1 ".$option ;
include('_search.php');
?>
|
|