Hey, I'm still working on the same forum system as my previous post. I am stuck at the point where I'm supposed to use SQL_CALC_FOUND_ROWS and FOUND_ROWS() functions in a SQL statement. This section of the forum script is made to make a multi-page format for each thread (which will later be used for multi-paging the posts as well).

My problem: My version of SQL is too old, SQL_CALC_FOUND_ROWS does not exist (or that it does, but won't work with a limit statment [as read from mysql.com]). Version = 3.23.

Is there an alternate SQL statement, that works with 3.23, that I can use to finish this multi-page script?

[EDIT:] NOTE: One thing I do not want to do is use premade code or scripts, this is a personal project to test my own skills, which went well until I got stuck with old version MySQL.

Why can't you upgrade to a newer version of MySql?

As much as I appreciate your response, I was hoping someone wouldn't ask that. I'm running a very important webserver in my home with a web-store on it. I don't want to run the risk of ANY problems resulting from updating the system, so right now updating is impossible. I need a replacement for SQL_CALC_FOUND_ROWS....even a work around is fine.

What does the SQL_CALC_FOUND_ROWS statement do? I am sorry, but I'm new to MySql and was unable to find it in the help.

fallen,

I don't understand -- you already know the "work-around". You mentioned it here, specifically inside this post. The count(*) bit...

True, but I guess in that post I was asking if you thought that would work, but no harm in trying I guess. Thanks for the help

You could use the php or get the number of rows or mysql_num_rows()