pulling form sql

[ball420]

i want my newest entries to be listed first on the page that reflects the database how would i go about this????

[jvrothjr]

Asc or Desc if you have a auto_increment field you can use this field to sort. by default it with read in order of ASC.

[aniesh82]

If the records you need to show has a date field or primary key columns, then use the select query

 

select * from tableName order by datefield ASC limit 0, 1

 

or

 

select * from tableName order by primaryKeyName ASC limit 0, 1

[ball420]

thanks i'll give it a try

any thoughts on the bad word filter

[ball420]

Asc or Desc if you have a auto_increment field you can use this field to sort. by default it with read in order of ASC.

 

what would my code look like for this??

[jvrothjr]

$QSdist = "SELECT * FROM Tblname Order By Field_Name Desc";[\code]