Preserved Topic: mysql_fetch problem... (Page 1 of 1)

Hey !
Im trying to post the 3 latest topics, from my msg board
to the frontpage of my site...

how can i do this ?


[newbie]

-> .A. <-

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

hehe.. ye abit cryptic maybe =)

what I want:
I want to get the 3 latest message topics, from my message board, on the main page...

a mysql script that gets the 3 latest written "topic" posts from the forum database.

...
hmm I think that made sence !? =)

the url btw is : www.saints.be the Forum is @ the "Board" link in top meny
( ! its under heavy reconstrution ! )


-> .A. <-

[This message has been edited by Air (edited 11-27-2001).]

Air: Welcome. I'm sure one of the experts will jump in and offer the correct solution but the way I'd do it, off the top of my head is: Do a sort of topics ORDER BY date DESC, grab the id and name (and pos. the name of the person who posted the message if you want) and then use a counter++ so that as you loop through you know when you've reached 3 - hold up I'd just throw a LIMIT 3 into the MySQL statement so that all the work is done by the MySQL (much quicker).

There is pos. something wrong there but that is my quick sketch solution.

Emps

[edit: So it was in English sentences rather than gobbledegook!!]


You're my wife now Dave

[This message has been edited by Emperor (edited 11-27-2001).]

Emperor knows of what he speaks. What I do is
$myquery = "select * from <table> order by <date field> DESC limit 3"

Or, taking a lesson from the master (Mr. Max):
Limit optimization
Sorting rows
Select syntax

aah.. my deepest thank you's !

it works !

atleast on localhost =)

*im so happy*

-> .A. <-

BTW, we can usually give you more exact solutions to this kind of problem if you post your table structures.

-jiblet