Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Prev / Next links...
- Thread starter buzzt
- Start date
sleipnir214
Programmer
Use the LIMIT clause of your SQL query (assuming MySQL :
In your prev/next links, have the links pass into your script the start and end points of the limit script.
Want the best answers? Ask the best questions: TANSTAAFL!
In your prev/next links, have the links pass into your script the start and end points of the limit script.
Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #4
Ok...here's what I have now. It works, except that I never get the last entry int the db (limit 2,2 only shows id #3 and not #4). Sorry it's a bit long...
if (!$limita) $limita=0;
else $limita=$limita;
$result = mysql_query("select * from $type where color like '%$color%' order by 'id' limit $limita,2"
;
$num_results = mysql_num_rows($result);
if (!$num_results)
{
echo "We're sorry... there do not seem to be any products which match your criteria. Please feel free to search again.\n<br><br>\n";
}
else
{
echo "Here are the results of your product search...\n<br><br>\n";
echo "<table width=100% cellpadding=0 cellspacing=0 border=0>\n";
for ($i=0; $i<$num_results; $i++)
{
$row = mysql_fetch_array($result);
$id = $row["id"];
$name = $row["name"];
$desc = $row["description"];
$color = $row["color"];
$avail = $row["avail"];
$image = $row["image"];
echo "<table width=100% cellpadding=0 cellspacing=0 border=0>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Product Name</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $name . ' ' . $id;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Description</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $desc . ".";
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Colors</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $color;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Availability</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $avail;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Sample Image</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
if ($image == "notavail.gif"
{
echo "Image Preview Unavailable";
}
else
{
echo "<a href=\"../graphic/products/" . $image . "\">Click Here</a>";
}
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Price</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo "Call 555-555-5555 for price.";
echo "\n</td>\n</tr>\n";
echo "</table>\n<br>\n";
}
}
//Here is where I set the mysql limit for next results
//page.
$increase = 2;
$limitb = ($limita+$increase);
echo "<a href=\"".$HTTP_SERVER_VARS['PHP_SELF']."?limita=".($limita-$increase)."&&type=$type&&color=$color\">Previous</a> | ";
echo "<a href=\"".$HTTP_SERVER_VARS['PHP_SELF']."?limita=".$limitb."&&type=$type&&color=$color\">Next</a><br><br><br>";
}
if (!$limita) $limita=0;
else $limita=$limita;
$result = mysql_query("select * from $type where color like '%$color%' order by 'id' limit $limita,2"
;$num_results = mysql_num_rows($result);
if (!$num_results)
{
echo "We're sorry... there do not seem to be any products which match your criteria. Please feel free to search again.\n<br><br>\n";
}
else
{
echo "Here are the results of your product search...\n<br><br>\n";
echo "<table width=100% cellpadding=0 cellspacing=0 border=0>\n";
for ($i=0; $i<$num_results; $i++)
{
$row = mysql_fetch_array($result);
$id = $row["id"];
$name = $row["name"];
$desc = $row["description"];
$color = $row["color"];
$avail = $row["avail"];
$image = $row["image"];
echo "<table width=100% cellpadding=0 cellspacing=0 border=0>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Product Name</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $name . ' ' . $id;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Description</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $desc . ".";
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Colors</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $color;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Availability</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo $avail;
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Sample Image</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
if ($image == "notavail.gif"
{
echo "Image Preview Unavailable";
}
else
{
echo "<a href=\"../graphic/products/" . $image . "\">Click Here</a>";
}
echo "\n</td>\n</tr>\n";
echo "<tr>\n";
echo "<td width=15% height=20 class=\"text\">\n";
echo "<b>Price</b>\n";
echo "</td>\n<td width=85% height=20 class=\"text\">\n";
echo "Call 555-555-5555 for price.";
echo "\n</td>\n</tr>\n";
echo "</table>\n<br>\n";
}
}
//Here is where I set the mysql limit for next results
//page.
$increase = 2;
$limitb = ($limita+$increase);
echo "<a href=\"".$HTTP_SERVER_VARS['PHP_SELF']."?limita=".($limita-$increase)."&&type=$type&&color=$color\">Previous</a> | ";
echo "<a href=\"".$HTTP_SERVER_VARS['PHP_SELF']."?limita=".$limitb."&&type=$type&&color=$color\">Next</a><br><br><br>";
}
sleipnir214
Programmer
If you change this:
for ($i=0; $i<$num_results; $i++)
{
$row = mysql_fetch_array($result);
to this:
while ($row = mysql_fetch_array($result))
{
Do you get the last row?
Want the best answers? Ask the best questions: TANSTAAFL!
for ($i=0; $i<$num_results; $i++)
{
$row = mysql_fetch_array($result);
to this:
while ($row = mysql_fetch_array($result))
{
Do you get the last row?
Want the best answers? Ask the best questions: TANSTAAFL!
- Status