Hi all,
I've worked out my pagination script and its paginating fine until I click next from page 2 at which point it stops displaying results. I know its something really simple, but can't see what lol.
Here is my code, anyone able to help?
Code: $connection = mysql_connect($hostname, $username, $password);
#
if (!$connection) {
#
die("A connection to the server could not be established");
#
}
#
/*Select Database */
#
mysql_select_db($database) or die("Database could not be selected!");
#
#
/*set variables*/
#
if (isset($_GET['MerchantType']) && isset($_GET['County'])){
#
$MerchantType = $_GET["MerchantType"];
#
$County = $_GET["County"];
#
echo $County . " " . $MerchantType;
#
}
#
#
/* Set current, prev and next page */
#
$page = (!isset($_GET['page']))? 1 : $_GET['page'];
#
$next = $page + 1;
#
$prev = $page - 1;
#
#
/* Max results per page */
#
$max_results = 5;
#
#
if (!$connection) {
#
die("A connection to the server could not be established");
#
}
#
/* Select Database */
#
mysql_select_db($database) or die("Database could not be selected!");
#
#
#
/* Figre out how many items there are in your DB */
#
$q = "SELECT * FROM $tablename WHERE County = '$County' AND MerchantType = '$MerchantType'";
#
$result = mysql_query($q) or die(mysql_error());
#
$total_results_pages = mysql_num_rows($result);
#
#
/* Must know where to begin grabbing the results from the DB */
#
$limitvalue = $page * $max_results - ($max_results);
#
#
// query
#
$q = "SELECT * FROM $tablename WHERE County = '$County' AND MerchantType = '$MerchantType' LIMIT $limitvalue, $max_results";
#
$result = mysql_query($q) or die(mysql_error());
#
$total_results = mysql_num_rows($result);
#
#
$total_pages = ceil($total_results_pages / $max_results);
#
#
#
#
echo '$total_results_pages = '.$total_results_pages;
#
echo '
';
#
echo '$total_results = '.$total_results;
#
echo '
';
#
echo '$max_results = '.$max_results;
#
echo '
';
#
echo '$total_pages = '.$total_pages;
#
echo '
';
#
echo '$page = '.$page;
#
echo '
';
#
echo '$next = '.$next;
#
echo '
';
#
echo '$prev = '.$prev;
#
echo '
';
#
echo '$limitvalue = '.$limitvalue;
#
echo '<hr>';
#
#
#
while ($row_details = mysql_fetch_array($result))
#
{
#
echo '
<table class="results" border="1" bordercolor="#1d9346">
<style="background-color:#FFFFFF" width="800" cellpadding="3" cellspacing="3">
<tr>
<td width="200" align="left" rowspan="7"><img src = "images/Test.png" /></td>
</tr>
<tr>
<td width="573" height="27" align="left">Name: '.$row_details['MerchantName'].'</td>
</tr>
<tr>
<td height="27" align="left">Address 1: '.$row_details['AddressLine1'].'</td>
</tr>
<tr>
<td height="27" align="left">Address 2: '.$row_details['AddressLine2'].'</td>
</tr>
<tr>
<td height="27" align="left">Telephone: '.$row_details['Telephone'].'</td>
</tr>
<tr>
<td height="27" align="left">Website: '.$row_details['Website'].'</td>
</tr>
<tr>
<td height="27" align="left">Description: '.$row_details['Description'].'</td>
</tr>
</table><br />';
#
}
#
#
// show next
#
if ($page == 1 && $page < $total_pages)
#
{
#
echo '<a href="?MerchantType='.$MerchantType.'&County='.$County.'&page='.$next.'">Next</a>';
#
}
#
#
// shoe prev & next
#
if ($page > 1 && $page < $total_pages)
#
{
# // prev link
#
echo '<a href="?MerchantType='.$MerchantType.'&County='.$County.'$page='.$prev.'">Previous</a> |';
// next link
#
echo '<a href="?MerchantType='.$MerchantType.'&County='.$County.'$page='.$next.'">Next</a> ';
#
#
}
#
#
// show prev
#
if ($page > 1 && $page == $total_pages)
#
{
#
echo '<a href="?MerchantType='.$MerchantType.'&County='.$County.'&page='.$prev.'">Previous</a>';
#
}
Sam
single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag with a php require or even inside the same page be able to show whatever link is clicked on that part
Changing files over
Just thought I'd start with the new forums looking really nice .Ok basically I've made this site www.sampleestateagent.com and the CMS and search function is all done for the buying part of the site.
How to display value in drop down list after form has been reloaded
Please bear with me as I am very new to php and html.I have a form with several drop down menus, the one at the top shows a list that when an item is selected fills in the form below including the
Php navigation
I have four buttons on a php page.If i click a button it will redirect to different php pages.How would i do that with php?
Problem with DB connection
Hello there! I'm new to this forum and I'm new to PHP coding also. I wrote something that doesn't make exactly what I thought it will. Can you give me a hand please. There we go:Code: [Select]
Array help
Hello i got this code to fetch data from database but it is not working it displays7ArrayArrayArrayArrayArrayArrayCode: if (isset($_POST['showrecord'])){ $query='SELECT * FROM artus_test';
How to write on database when a link is clicked?
Hi,
upgrade from 4.7 to ECC 6.0
Hi all,
When file included, REMOTE_ADDR is server's?
I have an index file that handles my site, basically index.php?page=ip will activate "require('./ip.php')".In the included file I have $ip = $_SERVER['REMOTE_ADDR']; and when it FIRST
please help me... my password gets encrypted but not able to get in database
hai guys, please help me... in the following function my password gets encrypted but not able to get in database.is any error in the query please help me...... <?php $email =