Re: results on multiple pages
| From: | Richard Emery | Date: | Tue, 16 Apr 2002 21:30:52 +0000 |
| Subject: | Re: results on multiple pages | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18571@lists.php.net to get a copy of this message | ||
I don't understand what you're saying
----- Original Message -----
From: James M Kupernik <kupernik@bcn.net>
To: 'Richard Emery' <remery@emeryloftus.com>
Sent: Tuesday, April 16, 2002 4:05 PM
Subject: RE: [PHP-DB] results on multiple pages
Because if I limit the record sort, then if the record I want at the top
is last, it won't catch it because of the limit.
-----Original Message-----
From: Richard Emery [mailto:remery@emeryloftus.com]
Sent: Tuesday, April 16, 2002 4:44 PM
To: James Kupernik
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] results on multiple pages
Why don't you let mysql sort and limit the records for you? That's easy
enough. Just keep track of where you are in the database and select
only the records that you need.
----- Original Message -----
From: James Kupernik <kupernik@bcn.net>
To: <php-db@lists.php.net>
Sent: Tuesday, April 16, 2002 3:20 PM
Subject: [PHP-DB] results on multiple pages
I am retrieve records from my MySQL table and I want to display the
results 12 per page along with allow for a sort. I was just send a query
to the table with a limit each time, but it didn't sort all the records,
so I need to load all the results into a table to sort then display.
Here is what I have for code....
<?php
Mysql_connect("localhost","user","pass");
mysql_select_db("countryloft");
if (!$nextpg) {
$i = 0;
} else {
$i = $i + 12;
}
$prodTbl = mysql_query("select * FROM countryloft WHERE category LIKE
'%folk%' ORDER BY displayorder");
$num_results = mysql_num_rows($prodTbl);
$itemsPerPage = 12;
echo "<table>";
$mycolumn = 1;
$maxcolumn = 3;
file://loop table until end of results
for ($i=$i; $i < $itemsPerPage; $i++)
{
$row = mysql_fetch_array($prodTbl);
echo "<td width=200 align=center><a
href=productinfo.php?prodID=".$row['record']."><img
src=http://www.thecountryloft.com/countryloft/yellowpics/".$row['image3'
]."
border=0>";
echo "<br><font size=2>".$row['title']."</font>";
echo "<br><font
size=2>".$row['price']."</font></td>\n";
if ($mycolumn == $maxcolumn)
{
echo "</tr>";
}
$mycolumn = $mycolumn + 1;
if ($mycolumn > $maxcolumn)
{
$mycolumn = 1;
}
}
echo "</table>\n";
echo "<a href=$PHP_SELF?i=$i&nextpg=yes>Next Page</a>";
?>
Any help would be great!!
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php