I am trying to make a Free For All links script and I need to know how to make it so when a site is submitted it is listed on top. I am programming in Php4 and MySQL, just to let you know.
Thanx to whoever helps me out
It depends, I use a field called position in some of my tables, its just yymmddhhmmss
(y = year, m=month, etc...)
and then do ORDER BY position DESC showing the most recent (largest number) first.
Hope that helps.
well, that does help a bit but i am using MySQL and I have the id (auto_increment) on it and Im thinking that if i could reverse the order at which the posts (links) are printed on the final page, it would work...i just dont know how to accomplish that.
well you could ORDER BY id, or id DESC, I'm useless at which to use, just try adding in ORDER BY into your mysql_query statements, heres an example...
$query=mysql_query("SELECT * FROM tablename WHERE name='$name' ORDER BY position",$db);
Hope that helps more.
wow, thanx, that did help. All I had to do was call in the MySQL with ORDER BY date and catagorize it by the date is was posted. Thanx a lot.
