mysql and php (rows)

[SypherGaming]

im wondering how to get php to read the latest row (instead of show them all) and when another one comes it replaces it once the page refreshes

[TomFromKWD]

personally I add:

 

ORDER BY rowname DESC LIMIT 1

 

to the SELECT * code

 

for example if you have auto_increamental ID row called ID it would be

 

ORDER BY ID DESC LIMIT 1

 

and then you can change to LIMIT 2, LIMIT 3 and so on depending on how many you want it to show

[SypherGaming]

thanks i worked out what you meant by watching a video im a noob when it comes to this stuff...

[TomFromKWD]

you got the code working ok?

 

I can give you a full example of what to change if you post me your existing code