Displaying MySQL Search Results!!!

Anon

I have written, using mysql, a forum and a search for the forum. I wish to limit the number of search results to 25 per page. This I have done. Like so:

while(($row = mysql_fetch_object($dbresult)) && ($count <= 25))
{
print("<a href=\"http://localhost/forum.php?messageID=$row->ID\">");

print("$row->title</a><br>\n");

$count++
}
}

but I have no idea of how I can create two links that allow a user to cycle backwards and forwards through the search result pages.
Please help! This is driving me up the wall!

Anon

Had this problem myself a few months ago and I couldn't find a clean way round it. What I ended up doing was creating links to the next/previous on each display of the results. So if you are displaying page 3 the links would create a page variable with either a value of 2 or 4.

I then execute the whole query each time and use the mysql_data_seek function to seek to the relevant record by multiplying the page variable by, in your case, 25.

I then simply spool off the next 25 records in much the same way as you have. The thing I don't like is having to re-execute the full query every time, but I cannot at present see another easy way round it.

Regards,

chrber

Anon

What I can advice is to use not "while" for this, but "LIMIT" feature of MySQL. I don't know if it is the easiest way, but I have done it so: when user presses "BACK" or "FORWARD", I just change OFFSET value for LIMIT in MySQL select statement. Have you got the idea? If it is not clear, I can explain in more details, but the main idea is like this.

Anon

Thank You both very much! I think you have saved my local sanitorium from one casualty anyway. I shall give both a try.
Thanks again!

Anon

The data seek function did the trick!
Thanks Alot!

P.S. I wonder if the mysql_data_seek() function makes use of the LIMIT function in MySQL? It seems to do the same thing.