Having some trouble trying to get the results to show on more than just one page.
What is happening is that when i input a subject or zip code, i get results and links on the bottom to show the number of pages, but when i click on them it gives me a broken link error
Here is the code that i have at the top of my html code before the <html> tag begins
Code: if(!isset($_GET['resultsPage'])){ $resultsPage = 1; } else { $resultsPage = $_GET['resultsPage']; } // Define the number of results per page $max_results = 9;
// Figure out the limit for the query based $from = (($resultsPage * $max_results) - $max_results);
that is whats supposed to get the pages, and the number of search results
here is t he code i have inside my <body> tag that echoes the results and builds the links for the pages
$sql = "SELECT * FROM tutorProfiles WHERE MATCH(subject, location) AGAINST('$subject*' '$location*' IN BOOLEAN MODE) LIMIT $from, $max_results"; $result = mysql_query($sql) or die("Problem, with Query:".mysql_error());
// Get number of articles, assign value to a variable $count = mysql_num_rows($result);
echo "<h3>Search Results</h3>"; echo "<p class='resultspara'>There is a total of $count results found on our database.</p>";