View Single Post
Old 04-10-2005   #2 (permalink)
scrowler
code anyone?
 
scrowler's Avatar
 
Join Date: Feb 2004
Location: New Zealand
Posts: 590

Send a message via MSN to scrowler Send a message via Skype™ to scrowler
Quote:
Originally Posted by ViciOuS
First off, the news is displayed from oldest(on the top) and newest(on the bottom), but how would i flip that so the new news is displayed on top?
simple. goto your SQL query, and add "ORDER BY id DESC" on the end, assuming you have an id column. if not, add one! this will return the same results but in reverse order (i.e. newest first)

Quote:
Originally Posted by ViciOuS
Secondly, i need someway of deleting unwanted news, can anyone help me here?
you need to make a secure panel (use sessions, hashing/encryption for passwords etc, check out this tutorial on how to make a membership system) and in that panel, make a page that lists all the entries, you can click the title of one and goto another page, where you use the SQL query: "DELETE FROM yournewstable WHERE id = '5'". this is an example, and would delete the database row with id = 5.

have fun
__________________
BioRUST Tutorials - the birthplace
scrowler is offline