1#@!#!123s

: / home / probwael / public_html /
Filename : new_ad.php
back
<?
$dcheck = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM _dadverts"));
if($dcheck>0) {
?>
			<div class="section section-overlay section-bg-3">
				<div class="container">
					<div class="row">
						<div class="col-md-12">
							<div class="ads-service">
								<h3 class="title">&nbsp;</h3>
								<span class="sub-title">&nbsp; </span>
								<img src="images/best_property_service.png" alt="" />
							</div>
						</div>
					</div>
				</div>
			</div>			
			
			
			<div class="section mtn-16">
				<div class="container">
					<div class="row">
						<div class="col-md-12">
							<div class="blog-index">
								<div class="row">
<?
$resultt = mysqli_query($conn, "SELECT * FROM _dadverts order by rand() limit 2") or die(mysqli_error($conn));
while($droww = $resultt->fetch_assoc()){
//get default image
$pid=$droww['id'];
$tid=$droww['transid'];
$dquer=mysqli_query($conn, "select id, picid from _dpics where transid='$tid' order by status desc limit 1") 
or die(mysqli_error($conn));
if(mysqli_num_rows($dquer)==0) {
$dphoto='images/nopic.gif';
}
else {
$dprow = $dquer->fetch_assoc();
$dpicid=$dprow['picid'];
$dphoto='webcontrol/items/'.$dpicid.'.jpg';
}
?>									
									<div class="col-sm-6">
										<div class="blog-item">
											<div class="blog-featured">
												<div class="content-featured">
													<a class="content-thumb" href="ad_detail?pid=<? echo $pid; ?>">
														<img src="<? echo $dphoto; ?>" alt="<? echo $droww['ititle']; ?>" />
														<span></span>
													</a>
												</div>
											</div>
											<div class="wrap-entry">
												<div class="entry-header">
													<p style="font-size:18px;">
														<a href="ad_detail?pid=<? echo $pid; ?>">
															<? echo $droww['ititle']; ?>
														</a>
													</p>													
												</div>
											</div>
										</div>
									</div>
									<!--div class="col-sm-6">
										<div class="blog-item">
											<div class="blog-featured">
												<div class="content-featured">
													<a class="content-thumb" href="#">
														<img src="images/blog/blog_2.jpg" alt="" />
														<span></span>
													</a>
												</div>
											</div>
											<div class="wrap-entry">
												<div class="entry-header">
													<p style="font-size:18px;">
														<a href="#">
															SNSO Properties - Showing you the benefits of owning rental properties
														</a>
													</p>
												</div>
											</div>
										</div>
									</div-->
<?
}
?>									
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>

<?
}
?>