Arkadaslar aşağıdaki koşulum çalışmıyor. önce veriyi çekiyorum fakat bir koşulda eğer 6 saat sonra ve durum (status) 0 ise yazdırsın değilse zaten yazmıyor.
|
|
|
$advertisement_query = mysql_query("SELECT * FROM andesite_advertisement ORDER BY advertisement_title DESC");
$num_log = mysql_num_rows($advertisement_query);
if($num_log <= 0){
echo '
'.ls_nothata.' |
'.ls_nothata.' |
'.ls_nothata.' |
';
}else{
$ads_ase = $advertisement_log_row['advertisement_base'];
$is_buyed_query = mysql_query("SELECT * FROM andesite_adsrice WHERE adsrice_adsase = '$ads_ase' AND adsrice_username = '$user_nickname'");
$is_buyed_row = mysql_fetch_assoc($is_buyed_assoc);
$timeA = $is_buyed_row['adrise_time'];
$timeB = date("d.m.Y H:i");
$timeDiff = strtotime($timeB) - strtotime($timeA);
echo $timeDiff.'
'.$timeB;
if($timeDiff > $ads_time && $is_buyed_row['adsrice_status'] == "0"){
while($advertisement_log_row = mysql_fetch_array($advertisement_query)){
echo '
'.$advertisement_log_row['advertisement_id'].' |
'.$advertisement_log_row['advertisement_title'].' |
'.ls_view.' |
';
}
}
}
?>
