Изреждане по име

Break4y

Registered
Здравейте, как мога да направя кода на страницата ми изрежда по име на картата ане като добавя примерно първо "aaa" после като добавя "bbb" и след това "aa" и те да излизат:
aaa
bbb
aa

искам да излизат
aa
aaa
bbb по име :)

Код:
<html>
<head>
<title>Demos</title>
<link rel='stylesheet' href='files/demosstyle.css' type='text/css' media='all' />
</head>
<body>
<table cellSpacing=0 cellPadding=3 width=100%>
<tr>
<td width=45% class=forumheader3>
<b><u>Map</u></b><br>
</td>
<td width=18% class=forumheader3>
<b><u>Author</u></b><br>
</td>
<td width=12% class=forumheader3>
<b><u>Time</u></b><br>
</td>
<td width=10% class=forumheader3>
<b><u>FPS</u></b><br>
</td>
<td width=15% class=forumheader3>
<b><u>Download</u></b>
</td>
</tr>




 <?php
//настройки за база данни
$dbhost = "mysql4.freehostia.com";
$dbuser = "brkbrk5_break";
$dbpass = "5as00ea";
$dbname = "brkbrk5_break";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

$select = mysql_query("SELECT * FROM demos ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$map = mysql_result($select, $i, "map");
$nick = mysql_result($select, $i, "nick");
$time = mysql_result($select, $i, "time");
$fps = mysql_result($select, $i, "fps");
$link = mysql_result($select, $i, "link");
echo '<tr>
<td width=30% class=forumheader3><b>' . $map . '</b></td>
<td width=15% class=forumheader3>' . $nick . '</td>
<td width=15% class=forumheader3><b>' . $time . '</b></td>
<td width=15% class=forumheader3>' . $fps . '</td>
<td width=15% class=forumheader3><a href="' . $link . '">Download</a></td>
</tr>';
}






mysql_close();
?>
</body>
</html>
 
Код:
<html>
<head>
<title>Demos</title>
<link rel='stylesheet' href='files/demosstyle.css' type='text/css' media='all' />
</head>
<body>
<table cellSpacing=0 cellPadding=3 width=100%>
<tr>
<td width=45% class=forumheader3>
<b><u>Map</u></b><br>
</td>
<td width=18% class=forumheader3>
<b><u>Author</u></b><br>
</td>
<td width=12% class=forumheader3>
<b><u>Time</u></b><br>
</td>
<td width=10% class=forumheader3>
<b><u>FPS</u></b><br>
</td>
<td width=15% class=forumheader3>
<b><u>Download</u></b>
</td>
</tr>




 <?php
//настройки за база данни
$dbhost = "mysql4.freehostia.com";
$dbuser = "brkbrk5_break";
$dbpass = "5as00ea";
$dbname = "brkbrk5_break";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

$select = mysql_query("SELECT * FROM demos ORDER BY nick ASC ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$map = mysql_result($select, $i, "map");
$nick = mysql_result($select, $i, "nick");
$time = mysql_result($select, $i, "time");
$fps = mysql_result($select, $i, "fps");
$link = mysql_result($select, $i, "link");
echo '<tr>
<td width=30% class=forumheader3><b>' . $map . '</b></td>
<td width=15% class=forumheader3>' . $nick . '</td>
<td width=15% class=forumheader3><b>' . $time . '</b></td>
<td width=15% class=forumheader3>' . $fps . '</td>
<td width=15% class=forumheader3><a href="' . $link . '">Download</a></td>
</tr>';
}






mysql_close();
?>
</body>
</html>
 

Back
Горе