'; include('databaseconfig.php'); $tblname = "annonser"; $dblink = mysql_connect( $databaseaddr, $username, $password); if ( ! $dblink) die("no connection to database"); $dbselect = mysql_select_db($dbname,$dblink); if ( ! $dbselect) die("no db selected"); $result = mysql_query("SELECT conf_value FROM config WHERE conf_name = \"num_annonser_news\""); $result = mysql_fetch_row($result); $select = mysql_query("SELECT * FROM $tblname WHERE `verifierad` = '1' AND (premium = 0 OR (premium = 1 AND betald = 1)) ORDER BY id DESC LIMIT ".$result[0] ,$dblink); if ( ! $select) die("selection failed: ".mysql_error()); $num_rows = mysql_num_rows( $select ); if ( ! $num_rows) die("det finns inga annonser att visa."); $firstnumber = $num_rows - 0; for ( $nr=0; $nr < $firstnumber; $nr++ ) { if( mysql_result($select,$nr,"bild") == true){ $bilden = ""; }else{ $bilden = ""; } $milantalet[0] = "Okänt"; $milantalet[1] = "0-2000"; $milantalet[2] = "2000-4000"; $milantalet[3] = "4000-6000"; $milantalet[4] = "6000-8000"; $milantalet[5] = "8000-10000"; $milantalet[6] = "10000-12000"; $milantalet[7] = "12000-14000"; $milantalet[8] = "14000-16000"; $milantalet[9] = "16000-18000"; $milantalet[10] = "18000-20000"; $milantalet[11] = "över 20000"; $text = mysql_result($select,$nr,"besk"); if ( strlen( $text ) > 250 ){ $text = substr($text,0,250)."..."; } $text = wordwrap($text, 50, "
"); $pris = mysql_result($select,$nr,"pris"); #$arsmodell = mysql_result($select,$nr,"arsmodell"); $arsmodell = (mysql_result($select,$nr,"arsmodell") == '1979') ? 'Innan 1980' : mysql_result($select,$nr,"arsmodell"); $miltal = $milantalet[mysql_result($select,$nr,"mil")]; print(" " . mysql_result($select,$nr, 'marke') . " " . mysql_result($select,$nr, 'rubrik') . " $bilden ".number_format($pris, 0, ",", " ") . " kr | ".$miltal." mil | Årsmodell ".$arsmodell."
".$text."
"); } print(""); layout_right(); ?>