$searchtotal) $number2 = $searchtotal;
if ($advanced == "yes") {
$sql5 = "SELECT * FROM $table_name1 WHERE $sqlcrap ORDER by id DESC LIMIT $startnumber,50";
} else {
$sql5 = "SELECT * FROM $table_name1 WHERE $field LIKE '%$find%' ORDER by id DESC LIMIT $startnumber,50";
}
?>
";
} else {
echo "error!";
}
include getenv('SITE_BASE_PATH')."/app/layout/template_bottom.php";
} elseif ((($uriarray[1] == "reporters") && (strlen($uriarray[3]) > 1)) && (strstr($uriarray[3], '.asp'))) {
// ################################################################################################################################
// ##### REPORTERS SHOW LIST OF REPORTERS FOR A PARTICULAR PARTICULAR COUNTY / CITY
$state_full_lower = $uriarray[2];
$sql1 = "SELECT * FROM states1 WHERE (state2='$state_full_lower' OR state3='$state_full_lower') LIMIT 0,1";
$result1 = mysql_query($sql1,$db);
$row1 = mysql_fetch_array($result1);
$state = $row1["state1"] ?? "";
$statefull = $row1["state2"] ?? ucfirst($state_full_lower);
$citycity = substr($uriarray[3],0,-4);
$sql3 = "SELECT * FROM cities2 WHERE state1='$state' AND city2='$citycity' LIMIT 0,1";
$result3 = mysql_query($sql3,$db);
$row3 = mysql_fetch_array($result3);
$city1 = $row3["city1"] ?? ucfirst($citycity);
$citystate = $city1.", ".$state;
// Debug info - remove this after testing
if (!$row1) {
echo "";
}
if (!$row3) {
echo "";
echo "";
}
$practicename = str_replace("_", "", $uriarray[4]);
$practicename = str_replace(".asp", "", $practicename);
$morelaw_title = $city1." ".$statefull." Court Reporters";
include getenv('SITE_BASE_PATH')."/app/layout/template_top.php";
?>
";
$sql1 = "SELECT * FROM cr1 WHERE (City LIKE '$city1' AND ST='$state') AND visible='' AND Rank <12 ORDER by Rank LIMIT 0,20";
$sql2 = "SELECT * FROM cr1 WHERE places LIKE '%$citystate%' AND visible='' AND Rank <12 ORDER by Rank LIMIT 0,20";
$sql3 = "SELECT * FROM cr1 WHERE places LIKE '%national%' AND visible='' AND Rank <12 ORDER by Rank LIMIT 0,20";
$sql4 = "SELECT * FROM cr1 WHERE (City LIKE '$city1' AND ST='$state') AND visible='' AND Rank >10 ORDER by PostDate,Rank LIMIT 0,20";
// #################################################################
// ########## LAYER ONE - PAID LOCAL
$result1 = mysql_query($sql1,$db);
echo "";
echo "";
if ($row1 = mysql_fetch_array($result1)) {
do {
?>
If you need assistance in finding a court reporter to assist you with your court reporting needs, feel free call MoreLaw at 918-582-6422 or 866-753-1142 for assistance or E-mail MoreLaw at info@MoreLaw.Com and we will assist you free of charge in finding a court reporter to help you.
Since 1996, MoreLaw's goal has been to collect and publish information about the best court reporters in the United States.
