mysqli_php
	include_once"includes/header.php";
include_once"includes/searchbox.php";
?>
<!-- start main -->
<!-- start main -->
<!-- start main_bg -->
<div class="middle">
	<div class="main_bg">
		<div class="wrap">
			<div class="main content_top">
				<div class="span1_of_12">
				<p>
The tutors in Wandsworth can be found here. We have ordered our tutors by the feedback on their tutoring performance. Many people are looking for a homework helper but we also offer teachers happy to give lessons for the longer term. <br>
 					mysqli_php
						 $condition = "status='Approved'   and user_type=1 and (postcode like '%SW%')";
						 
 							$resusers = $SDB->getAllResult("users",$condition);
							$num = $SDB->checkNumRows("users",$condition);
 						if($num<=0){
							echo '
							<div class="featured">
									 Opps! No Result Found.
								</div>';
 						}
						while($tusers = mysql_fetch_object($resusers)){
							$expcat = explode(',',$tusers->subject_cat_id);
							$categorysel = $SDB->getAllResult("subject_category",' 1');
							$category = "";
							while($categoryrow = mysql_fetch_object($categorysel)){
								if(in_array($categoryrow->id,$expcat)){
									$category .= ",".$categoryrow->subject_category;
								}
							}

							$expsubj = explode(',',$tusers->subject_subcat_id);
							$subjectsel = $SDB->getAllResult("subject_subcategory",' 1');
							$subject = "";
							while($subjectrow = mysql_fetch_object($subjectsel)){
								if(in_array($subjectrow->id,$expsubj)){
									$subject .= ",".$subjectrow->subject_subcategory;
								}
							}
 
							$from = $SDB->SingleRowDb("tutor_address","tutor_id=".$tusers->id);
							$imgurlr = str_replace(" ","",trim($imgurl.$tusers->pro_img));
							echo ' <div class="featured">
									<A HREF="tutors-profile?tuid='.$tusers->id.'">
			<img class="forr" src="'.$tusers->pro_img.'" width="170" height="180" style=" float:left; margin-right:10px;  border:2px solid #fff;"></A>
									<A HREF="tutors-profile?tuid='.$tusers->id.'"><h3 style="font-size:20px;">'.$tusers->title.' '.$tusers->fname.' '.$tusers->lname.'</h3></A>
									    <!--<p class="j1"> <img src="images/fromicon.png" width="15" height="11">&nbsp;<B style="font-weight:bold;color:#000066;font-size:15px;">From : </B>'.$from->town_city.', '.$from->postcode.'</p>--><br>
										<p class="j2"> <img src="images/subject.png" width="13" height="18"  style="float:left; margin:2px 5px 0 0;"> <strong style="font-weight:bold;color:#000066;font-size:15px;">Subject : </strong>'.ltrim($category,",").', '.ltrim($subject).'</p>
								<p class="j2" style="float:left;"> <img src="images/subject.png" width="13" height="18"  style="float:left; margin:2px 5px 0 0;"> <strong style="font-weight:bold;color:#000066;font-size:15px;">Area Covered : </strong>'.$tusers->area_cover.'</p>
										
									<p class="j3"> <strong></strong>'.substr($tusers->about_self,0,145).'.....</p>
									<a href="tutors-profile?tuid='.$tusers->id.'"> <input class="btnk" name="" type="button" value="View Full Profile" style="margin-top:-7px;"> </a>	
								</div>';
 
						}
					?>
 		</div>
mysqli_php
	include_once"includes/right.php";
 	include_once"includes/footer.php";
?>