table_name = 'categories'; $nodes_list = $nodes->build_list(0 , 0); $name = $_REQUEST['name']; function limit_words($string, $word_limit) { $words = explode(" ",$string); return implode(" ",array_splice($words,0,$word_limit)); } $PHid = 0; ?> Ροή Ειδήσεων, SportsNow!
Ροή Ειδήσεων
1) { $pages = new Paginator; $pages->items_total = $num_rows; $pages->mid_range = 15; $pages->paginate(); $query = 'SELECT * FROM kataxoriseis WHERE tipos="prods" AND cert="1" AND date <= NOW() ORDER BY date DESC'.$pages->limit; $links = mysql_query($query) or die('Query failed: ' . mysql_error()); while ($thelink = mysql_fetch_array($links, MYSQL_ASSOC)) { $query = 'SELECT * FROM users WHERE id="'.mysql_real_escape_string($thelink["timi"]).'" '; $users = mysql_query($query) or die('Query failed: ' . mysql_error()); $user = mysql_fetch_array($users, MYSQL_ASSOC); $query = 'SELECT * FROM categories WHERE id="'.mysql_real_escape_string($thelink["id"]).'" '; $cats = mysql_query($query) or die('Query failed: ' . mysql_error()); $cat = mysql_fetch_array($cats, MYSQL_ASSOC); $string = $thelink["elm1"]; $test = strip_tags($string); $limited = limit_words($test, 20).'...'; $malakia = strtotime($thelink["date"]); setlocale(LC_ALL, 'greek'); $ret = strftime("%d.%m.%Y ", $malakia); $ret = mb_convert_encoding($ret, "UTF-8", "ISO-8859-7"); ?>
1) {?>
display_pages(); ?>
0 LIMIT 1 '; $bannersbot = mysql_query($query) or die('Query failed: ' . mysql_error()); while($bannerbot = mysql_fetch_array($bannersbot)) { ?> '') { ?> " target="_blank">" alt="Sportnow.gr" /> " alt="Sportnow.gr" /> '') { ?>