PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- $q1 = $this->db->query("SELECT id,img,date,title_".$this->lng.",short_".$this->lng." FROM ".NEWS_TBL." WHERE cid='".mysql_real_escape_string($d['id'])."' AND active='1' AND on_main='1' AND bash='2' ORDER BY id DESC LIMIT 2");
- if($q1['num_rows'] !== 0){
- echo '
- <td class="lr">
- <div class="newsCatBlock">
- <a href="index.php?l='.$this->lng.'&m=news&id='.mysql_real_escape_string($d1['id']).'" class="title">'.$d1['title_'.$this->lng].'</a> <span class="date">'.date("j.n.Y [g:i]", $d1['date']).'</span> <span class="short"><img src="files/news/thumbs/'.$d1['img'].'" width="100px" border="1" alt="'.$d1['title_'.$this->lng].'" class="newsBlockIMG_Right" />'.nl2br($d1['short_'.$this->lng]).'</span>
- </div>
- </td>
- ';