Menu
Community /Pin to ProfileBookmark
@NogDogMay 17.2009 — #
Where
display in alphabetical
Hi
Is there anyway the below can be alterd to display films in alphabetical order
[CODE]$result = mysql_query(“SELECT * FROM `films` WHERE `TIMESTAMP` > DATE_SUB( NOW(), INTERVAL 7 DAY)”);
echo “<body bgcolor=”black” text=”red” link=”fuchsia” vlink=”purple” alink=”fuchsia”>n”;
echo ” <center>
<h1><b><font size=6 color=red>Last 7 Days</font></b></h1>
</center> <left>
<table border=’0′>
<hr></left>” ;
$i = 0;
while($row = mysql_fetch_array($result))
{
$i++;
echo “</br>”;
echo “<b><font size=5 color=fuchsia>{$row[‘Title’]}</font></b>”;
echo “</br>”;
echo “</br>”;
echo “<b><font color=red>Genre: </font></b><font color=fuchsia>{$row[‘Extras’]}</font>”;
echo “</br>”;
echo “</br>”;
echo “<b><font color=red>Plot: </font></b><font color=fuchsia>{$row[‘Info’]}</font></b>”;
echo “</br>”;
echo “</br>”;
echo “<a href=http://somewhere/filesarehere/{$row[‘Download’]}>Download</a>”;
echo ” – – “;
echo “<a target=’main’ href=’http://somewhere/filesarehere/{$row[‘View’]}’>View</a>”;
echo “</br>”;
echo “</br>”;
echo “<hr>”;
}
?>
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogMay 17.2009 — #[code=php]
$result = mysql_query("SELECT * FROM films WHERE TIMESTAMP > DATE_SUB( NOW(), INTERVAL 7 DAY) ORDER BY xxxxxxxx");
[/code]Where
xxxxxxxxxxx