<?php

$imei = $_REQUEST['imei_num'];
$appid = $_REQUEST['app_id'];
$action = $_REQUEST['action'];
$action = $_REQUEST['creative_id'];
$action = $_REQUEST['creative_type'];

$conp = mysql_pconnect('localhost','root', '') or die('error in connection' . mysql_error());

mysql_select_db("advertiser") or die('could not select db' . mysql_error());

$query = "select a.* from creative_ad a inner join adserve b on a.serve_id = b.serve_id
WHERE b.start_date < curdate() and b.end_date > curdate()";

$rs = mysql_query($query);

$arr = array();

while ($obj = mysql_fetch_object($rs)) {
 	$arr = $obj;

 }

$json = json_encode($arr);

echo $json;

mysql_close($conp);

?>