I have read the articles on placing previous and next links on my pages, and they work if I do a generic query, but I have queries that are based of multiple tables instead of just one, and I am wondering about the formatting.
The article I am reffering to is:
http://www.phpbuilder.com/columns/rod20000221.php3
I get a lot of results returned and I need something to limit those results as well as provide a way to the next set of 5 or 10 or whatever.
Here is my query:
signin_connect ()
or exit();
$result = @("select category.category, classification.cname, commissions.type, examples.example_url, program.name, description.description, integration.integration_url, navagation.signup_url, navagation.moreinfo_url
from program, category, description, navagation, commissions, integration, examples, classification
where program.classification_id = classification.classification_id and program.program_id = examples.program_id and program.program_id = integration.program_id and program.category_id = category.category_id and program.commission_id = commissions.commission_id and program.program_id = description.program_id and program.program_id = navagation.program_id;");
if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
This may look convaluted 🙂 but it works great and it's actually pretty fast with it's output. None of the articles I've read talk about handling anything more than a single table or they base it off of a simple keyword search.
Any help would be great.
