include '../../conchshell/config.php';
require('../../conchshell/encryption.php');
require('../../conchshell/functions.php');
$advice_owner = $_REQUEST['code_id'] ;
$cur1= mysql_query("select * FROM mediators WHERE law_code = '$advice_owner' AND code_type = 'mediator' " ) or die(mysql_error());
// fetch the succesive result rows
while( $row1=mysql_fetch_row( $cur1 ) ) {
$nbrow1++;
// $law_code = $row1[1];
$law_first= $row1[2]; // get the field "ID"
$law_last= $row1[3]; // get the field "Index"
$law_title = $row1[4]; // get the field "FirstName"
$law_email= $row1[5]; // get the field "LastName"
$law_phone = $row1[6]; // get the field "PCatagory"
$co_name = $row1[7]; // get the field "PCatagory"
$co_alt= $row1[8]; // get the field "PCatagory"
$co_add1 = $row1[9]; // get the field "PCatagory"
$co_add2 = $row1[10]; // get the field "PCatagory"
$co_city = $row1[11]; // get the field "PCatagory"
$co_province = $row1[12]; // get the field "PCatagory"
$co_postal = $row1[13]; // get the field "PCatagory"
$co_phone = $row1[14]; // get the field "PCatagory"
$co_website = $row1[15]; // get the field "PCatagory"
$co_email = $row1[16]; // get the field "PCatagory"
$time_zone = $row1[17]; //get the field employee priority
$law_type = $row1[18]; // get the field "PCatagory"
$helper_type = $row1[26]; // get the field "PCatagory"
$thumbnail = $row1[28];//$admin_id = $row1[20];
$thumbnail = "../mediators/" . "$thumbnail" ;
$company_description = $row1[29];//$admin_id = $row1[20];
$company_description = substr($company_description, 0, 500);
$contact_description = $row1[30];//$admin_id = $row1[20];
$contact_description = substr($contact_description, 0, 500);
$marketing_visible = $row1[31];//$admin_id = $row1[20];
}
?>