Displaying 10 topics at a time

[Yeni]

Hi,

Can anyone show me how to display (using mySql & php) 10 topics PER HTML PAGE? Is there an example that i can refer to?

Thanks,
neu-bEeEee

[suntra]

In your MySQL query, you can use LIMIT.

Syntax : LIMIT <start - 1>, 10

Example :

SELECT * FROM topics LIMIT 0, 10

Will select the first ten results

SELECT * FROM topics LIMIT 5, 10

Will select topics 6-7-8-9-10-11-12-13-14-15

[Yeni]

Hey thanks for replying and teaching!

I'll gif it a try later!