=stripslashes($ad_title)?>
Acest produs este vandut
}?>
if($ad_has_picture == '1'){
$pic = mysql_query("SELECT `filename` FROM `picture` WHERE `pic_ad_id` = '".$ad_id."' LIMIT 0,1");
$res = mysql_fetch_array($pic);
$poza_thumb = $res['filename'];
$poza = str_replace("_tmb1","",$res['filename']);
$img = $_LINK.'images/'.$poza_thumb;
echo ' ';
}
?>
Descriere
=stripslashes($ad_description)?>Detalii anunt
|
Detalii generale
Vandut de: | =stripslashes($user_name)?> ( =$user_score?> /# =$user_voters?>) Grad =$user_name?> |
Email: | Contactati vanzator}else{?>=$user_email?>}?> |
Comentarii
Ai vreun comentariu? Poti adauga dupa autentificare.
}else{?> }?>
$sql = "SELECT * FROM `comments` WHERE `comment_ad` = '".$ad_id."' ORDER BY `comment_id` DESC";
$res = mysql_query($sql);
$afectate = mysql_affected_rows();
$i=0;
while($i < $afectate) {
while($row = mysql_fetch_array($res)){
$sql_user = mysql_query("SELECT `user_name`, `user_id` FROM `user` WHERE `user_id` = '".$row['comment_userid']."'");
$r_user = mysql_fetch_array($sql_user);
$user_id_com = $r_user['user_id'];
$user_name_com = $r_user['user_name'];
if($i%2 == 0){
?>
Publicat de =$user_name_com?> la: =date("d.m.y h:i:s",$row['comment_date'])?> =stripslashes($row['comment_body'])?>Publicat de =$user_name_com?> la: =date("d.m.y h:i:s",$row['comment_date'])?> =stripslashes($row['comment_body'])?> |
Poate va intereseaza si anunturile urmatoare:
$title_array = explode(" ",$ad_title); $q = "SELECT c.cat_id, c.cat_name, a.* FROM ad as a, category as c WHERE ((c.cat_id = a.ad_cat_id) AND (a.ad_title LIKE '%".$title_array[0]."%') AND (a.ad_id != '".$ad_id."')) ORDER BY a.ad_id DESC LIMIT 0,3"; $rs = mysql_query($q); $affected = mysql_affected_rows(); if($affected > 0){ while($r = mysql_fetch_array($rs)){ $pic = mysql_query("SELECT `filename` FROM `picture` WHERE `pic_ad_id` = '".$r['ad_id']."' LIMIT 0,1"); $res = mysql_fetch_array($pic); $poza = $res['filename']; if($poza == '') $img = 'http://www.animalpedia.ro/cabinete-veterinare/img/fara_imagine.gif'; else $img = $_LINK.'/images/'.$poza; ?>=stripslashes(trim_text($r['ad_title'],100));?>=stripslashes(trim_text($r['ad_description'],150));?> |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() =date("d.m.Y",$r['ad_date'])?> |
} }else{?> $q = "SELECT c.cat_id, c.cat_name, a.* FROM ad as a, category as c WHERE ((c.cat_id = a.ad_cat_id) AND (a.ad_id != '".$ad_id."')) ORDER BY a.ad_id DESC LIMIT 0,3"; $rs = mysql_query($q); while($r = mysql_fetch_array($rs)){ $pic = mysql_query("SELECT `filename` FROM `picture` WHERE `pic_ad_id` = '".$r['ad_id']."' LIMIT 0,1"); $res = mysql_fetch_array($pic); $poza = $res['filename']; if($poza == '') $img = 'http://www.animalpedia.ro/cabinete-veterinare/img/fara_imagine.gif'; else $img = $_LINK.'/images/'.$poza; ?>
=stripslashes(trim_text($r['ad_title'],100));?>=stripslashes(trim_text($r['ad_description'],150));?> |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() =date("d.m.Y",$r['ad_date'])?> |
}?> }?>