What I need is a way to recall the whole database in descending order by artnum (the number of each entry). artnum begins at 001 and continues 002 003 and so on. Then it echoes them like this:
<div class="big"><a href="newsn.php?art=[INSERT art_title_url HERE]">[INSERT art_title HERE]</a></div> [INSERT art_desc HERE]<br /><br />
I already know how to fill them in, I just don't know how to make it so that I have one for each entry, so it would be like:
<div class="big"><a href="newsn.php?art=[INSERT 002 art_title_url HERE]">[INSERT 002 art_title HERE]</a></div> [INSERT 002 art_desc HERE]<br /><br /> <div class="big"><a href="newsn.php?art=[INSERT 001 art_title_url HERE]">[INSERT 001 art_title HERE]</a></div> [INSERT 001 art_desc HERE]<br /><br />
(the 001 and 002 are the artnum numbers)
This is what I have so far, but I think I'm wrong:
$result = mysql_query("SELECT * FROM articles ORDER BY artnum DESC");
while($row = mysql_fetch_array($result))
{
$art_title=$row['art_title'];
$art_title_url=$row['art_title_url'];
$art_desc=$row['art_desc'];
}The main thing about that code is I need a way to echo every piece of information.
I'm sorry if you don't understand, it's sort of hard to explain. If you want, post here and I'll try to say it to where you'll understand. My MySQL version is 5.0.91-log
