Sukurkit koda

Sukurkit kas koda kuris isvestu siunciamiausias dainas, ir kad pvz butu su puslapiavimu kas 15 dainu.

http://electro.ql.lt/imk.png

Turėtų būti kažkas tokio, pasitvarkyk dar pagal save.

<?php

// Connects to MySQL server & selects database
$cfg['mysql_connect'] = mysql_connect("127.0.0.1", "#", "#") or die(mysql_error());
mysql_select_db("#", $cfg['mysql_connect']) or die(mysql_error());

// Configuration
$cfg['rows_per_page'] = 15;
$tmp['page'] = 1;
if (isset($_GET['page'])) {
	$tmp['page'] = $_GET['page'];
}
$tmp['offset'] = ($tmp['page'] - 1) * $cfg['rows_per_page'];

// Shows data from MySQL
$tmp['mysql_query'] = mysql_query("SELECT * FROM lentele ORDER BY kiek_atsisiunte DESC LIMIT ". $tmp['offset'] .", ". $cfg['rows_per_page'] ."", $cfg['mysql_connect']) or die(mysql_error());;
while ($tmp['data'] = mysql_fetch_array($tmp['mysql_query'])) {
	echo "<a href=\"http://www.bestelectro.lt/daina.php?i=&dainos_id=". $tmp['data']['download_url'] ."\">". $tmp['data']['pavadinimas'] ." (Atsisiųsta: ". $tmp['data']['kiek_atsisiunte'] .")</a><br />";
}

// Shows links to pages
$tmp['mysql_query'] = mysql_query("SELECT * FROM lentele", $cfg['mysql_connect']) or die(mysql_error());
$tmp['number_of_rows'] = mysql_num_rows($tmp['mysql_query']);
$tmp['pages'] = ceil($tmp['number_of_rows'] / $cfg['rows_per_page']);
if ($tmp['page'] > 1) {
	$tmp['page_fl'] = $tmp['page'] - 1;
	echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=1\">[First]</a>";
	echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['page_fl'] ."\">[Previous]</a>";
}
if ($tmp['page'] < $tmp['pages']) {
	$tmp['page_fl'] = $tmp['page'] + 1;
	echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['page_fl'] ."\">[Next]</a>";
	echo "<a href=\"". $_SERVER['PHP_SELF'] ."?page=". $tmp['pages'] ."\">[Last]</a>";
}

// Closes MySQL connection
mysql_close($cfg['mysql_connect']);

?>

Dekui :))

Jei dar ko nors reikės - kreipkis :)