shownews.php

[shiny]

how would i have the newsposts list down the page, the most current post first, right now i post some news and it only shows the last post.

[Ken2k7]

Does the newspost have an ID column?

 

SELECT * FROM `table_name` ORDER BY `id` DESC

[shiny]

$query = "SELECT * FROM news_posts ORDER BY id DESC LIMIT 0 , 5";

 

i tried changing up those values earlier, or am i even where i should be. thats in the shownews.php. lol

[burn1337]

call it by rows. $query = "select * from tbl_name"

$count = get_rows (i.e. mysql_num_rows)

$count --;  (i.e. mysql_result($query, $count, field int))

then loop a display decrement $count after each post is displayed

[DjMikeS]

Can you post some code because: $query = "SELECT * FROM news_posts ORDER BY id DESC LIMIT 0 , 5"; should work just fine...

[burn1337]

Go look at the code I posted in the Tree menu thread, I think you should be able to get the picture of what I mean by that, sorry I'm in the middle of coding my forum.