 |
";
}
if($rows1[state_no]) {
if($rows1[location]) {
$location_row = select_qry("local_area","no",$rows1[location],$connect);
$location = $location_row['city_name'];
if($location_row['town_name']) {
$location .= "-".$location_row['town_name'];
}
$location .= ", ".$location_row[state_name];
} else {
$location_row = select_qry("local_area","state_no",$rows1[state_no],$connect);
$location = $location_row[state_name];
}
} else {
$location = "Not Mentioned";
}
if($rows1[pay]) {
for($pa=1;$pa<21;$pa++) {
$pa_val = $pa * 5;
$n_pa_val = ($pa + 1) * 5;
if($pa_val == $rows1[pay]) {
if($pa == 0) {
$pay = "Less than $10 / Hr";
} else if($pa == 20) {
$pay = "More than $100 / Hr";
} else {
$pay = "$".$pa_val."+ to ".$n_pa_val." / Hr";
}
break;
}
}
} else {
$pay = "Not Mentioned";
}
if($rows1[e_type] == 'r') {
$e_type = "Registered";
} else if($rows1[e_type] == 's') {
$e_type = "Sole Trade";
} else {
$e_type = "Not Mentioned";
}
if($rows1[exp]) {
for($ex=1;$ex<22;$ex++) {
$p_ex = $ex - 1;
if($ex == $rows1[exp]) {
if($ex == 1) {
$exp = "Less than 1 Year";
} else if($ex == 21) {
$exp = "More than 20 Years";
} else {
$exp = $p_ex."+ to ".$ex." Years";
}
break;
}
}
} else {
$exp = "Not Mentioned";
}
if($rows1[gst] == 'y') {
$gst = "GST Registered";
} else if($rows1[gst] == 'n') {
$gst = "GST Not Registered";
} else {
$gst = "Not Mentioned";
}
if($rows1[c_type] == 'f') {
$c_type = "Full Contract";
} else if($rows1[c_type] == 's') {
$c_type = "Sub-Contract";
} else {
$c_type = "Not Mentioned";
}
$payment = nl2br($rows1[payment]);
$description = nl2br($rows1[description]);
$other = nl2br($rows1[other]);
$reg_date = date("d/m/Y",strtotime($rows1[reg_date]));
if($keyword1) {
$keyword_pattern = "/$keyword1/i";
$description = preg_replace($keyword_pattern, "$keyword1", $description);
}
if($keyword2) {
$keyword_pattern = "/$keyword2/i";
$description = preg_replace($keyword_pattern, "$keyword2", $description);
}
if($keyword3) {
$keyword_pattern = "/$keyword3/i";
$description = preg_replace($keyword_pattern, "$keyword3", $description);
}
if($com_row[logo]) {
$com_logo = "http://serviceimg.totalinfo.co.nz".$com_row[logo];
} else {
$com_logo = "/images/noimage3.gif";
}
if($com_row[company_location]) {
$com_lo_row = select_qry("local_area","no",$com_row[company_location],$connect);
$com_location = $com_row[company_addr1].", ".$com_lo_row['city_name'];
if($com_lo_row['town_name']) {
$com_location .= "-".$com_lo_row['town_name'];
}
$com_location .= ", ".$com_lo_row[state_name];
}
if($com_row[company_phone]) {
$full_phone = explode(";",$com_row['company_phone']);
$phone = "Tel: ".$full_phone[0]." ".$full_phone[1];
}
if($com_row[company_mobile]) {
$full_mobile = explode(";",$com_row['company_mobile']);
$mobile = "Fax : ".$full_mobile[0]." ".$full_mobile[1];
}
if($com_row[company_fax]) {
$full_fax = explode(";",$com_row['company_fax']);
$fax = "Mob : ".$full_fax[0]." ".$full_fax[1];
}
include("./member_opt.php");
?>
|
|
|||
|
|||
|
|||
|
|
|
