displaying results on multiple pages.

[Anon]

I'm fairly new to PHP and MySQL and am having trouble getting my head around displaying results across multiple pages. Here is what I'm trying to do...

query database - get total number of results
$result = mysql_query("SELECT COUNT(id) AS total FROM listings WHERE title LIKE '%$search%' OR content LIKE '%$search%' OR link LIKE '%$search%'";

query database - get results
Same as above except with the COUNT() AS

create a page with forward and back buttons to step thru the results.

can anyone explain to me how to calculate moving thru the results so I can build this script.

Thanx in advance.

[Anon]

This question is asked so often an article on the subject has been written.

http://www.phpbuilder.com/columns/rod20000221.php3

[Anon]

Thanx 😉

Thats exactly what I've been looking for.