";
include('../include/nav2.php');
echo "
My Ads
";
$page = $_GET["page"];
if($p=="" || $p<=0)$p=1;
$norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM native_ads WHERE uid='$myid'"));
$target = $norm[0];
$items_per_page= 100;
$num_pages = ceil($target/$items_per_page);
if(($p>$num_pages)&&$page!=1)$p= $num_pages;
$limit_start = ($p-1)*$items_per_page;
$sql = "SELECT id, cat_id, uid, title, ad_thumb, image_url2, description, fea, active, time_added, ad_country, ad_state, ad_dist, ad_city, ad_pincode, ad_area, ad_note, ad_link, ad_type, ad_duration, ad_views FROM native_ads WHERE uid='$myid' ORDER BY id ASC LIMIT $limit_start, $items_per_page";
$items = mysql_query($sql);
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$bhopu = substr("$item[3]", 0, 20);
$chopu = substr("$item[6]", 0, 107);
if($item[7]=='1')
{
$whichclass = "
Featured
";
}else{
$whichclass = "";
}
if($item[8]=='1')
{
$astatus = "Active";
}else if($item[8]=='0'){
$astatus = "Deactive";
}else if($item[8]=='2'){
$astatus = "On self Hold";
}
$catname = getcatname($item[1]);
$catlink = getcatlink($item[1]);
$jdt = date("j.m.Y",$item[9]);
$lnk = "
";
echo "$lnk";
}
}
echo "