Menu
▾
▴
[Devil-linux-commit] web/downloads index.php,1.1.1.1,1.2
|
From: Heiko Z. <smi...@us...> - 2004-10-18 23:31:09
|
Update of /cvsroot/devil-linux/web/downloads In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9355/downloads Modified Files: index.php Log Message: randomize order of download locations Index: index.php =================================================================== RCS file: /cvsroot/devil-linux/web/downloads/index.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- index.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ index.php 18 Oct 2004 23:31:00 -0000 1.2 @@ -16,7 +16,7 @@ global $sql_host, $sql_username, $sql_password, $dbname; $db_connect = new db_sql; $db_connect->connect($sql_host, $sql_username, $sql_password, $dbname); - $recordset = $db_connect->query("SELECT * FROM tbl_download_locations ORDER BY description"); + $recordset = $db_connect->query("SELECT * FROM tbl_download_locations ORDER BY rand()"); while ($data = $db_connect->fetch_array($recordset)) { echo "<h2>$data[description]</h2>"; @@ -28,7 +28,7 @@ global $sql_host, $sql_username, $sql_password, $dbname; $db_connect = new db_sql; $db_connect->connect($sql_host, $sql_username, $sql_password, $dbname); - $recordset = $db_connect->query("SELECT * FROM tbl_download_sites WHERE locationid=".$locationid." ORDER BY description"); + $recordset = $db_connect->query("SELECT * FROM tbl_download_sites WHERE locationid=".$locationid." ORDER BY rand()"); echo "<ul>"; while ($data = $db_connect->fetch_array($recordset)) { |
