i hate offsets :)

[Anon]

Hi,

Ive already posted regarding this but cant seem to get the script working using the previous suggestions.

Its displaying two product images, but when you click on the next button it displays the same two, the offset is not taking effect. Any ideas anyone?

<?
require("func_connect.php");
connect ("localhost","tantrum");

if(isset($offset)) {
$offset = $offset;
}
else {
$offset = 0;
}

// For 20 rows, use 21
$numrows = 3;

$SQ = "SELECT * FROM products, company WHERE products.cid=$cid AND company.cid=$cid LIMIT

$offset,$numrows";

// print the "Previous" link if offset is NOT 0
if ($offset != 0) {
print "<a href=\"offset.php?cid=1&offset=\" . ($offset - $numrows) . \">Previous</a>\n";
}

// start a counter so you ONLY PRINT $numrows rows
$count = 1;

// now print your rows for this page
$result = @("SELECT * FROM products, company WHERE products.cid=$cid AND

company.cid=$cid");
if (@$data = mysql_fetch_array($result))

{
do {

$title = $data["title"];
$thumbnail = $data["thumbnail"];
$id = $data["id"];
$info = $data["info"];

echo "<a href=\"$PHP_SELF?id=$id&cid=$cid\"><img src=\"$thumbnail\" hspace=\"5\" border=\"1\"

alt=\"$title\"></a>";

$count++;

} while (($data = mysql_fetch_array($result)) && ($count < 3) );
}

else {
echo "</p>No items match your selection</p>.";
}

// finally, see if there is a 21st row. If there IS, then print the NEXT link

if (@$data = mysql_fetch_array($result)) {
print "<a href=\"offset.php?cid=1&offset=" . ($offset + $numrows) . "\">Next</a>";
}
?>

Any help would be greatly appreciated.
Thanks,
dast

[Anon]

http://www.phpbuilder.com/columns/rod20000221.php3

[dast1]

yeah I know, ive read that article, quite a few times actually! luckily enough i've found a way round it from a previous post.

<?
require("func_connect.php");
connect ("localhost","tantrum");

$limit=3;
$Prev = "Previous";
$Next = "Next";

$numresults=mysql_query("SELECT * FROM products, company WHERE products.cid=$cid AND

company.cid=$cid ORDER BY id ASC");
$numrows=mysql_num_rows($numresults);

if (empty($offset)) {
$offset=0;
}

$sql = "SELECT * FROM products, company WHERE products.cid=$cid AND company.cid=$cid ORDER BY

id ASC limit $offset,$limit ";
$result = mysql_query($sql) or die("Could not execute query.");
while ($data = mysql_fetch_array($result)) {

do {
$title = $data["title"];
$thumbnail = $data["thumbnail"];
$id = $data["id"];
$info = $data["info"];

echo "<a href=\"$PHP_SELF?id=$id&cid=$cid\"><img src=\"$thumbnail\" hspace=\"5\" border=\"1\"

alt=\"$title\"></a>
";
} while ($data = mysql_fetch_array($result));
}
mysql_free_result($result);

$pages=intval($numrows/$limit);

if ($numrows%$limit) {
$pages++;
}

for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
print "<a href=\"$PHP_SELF?cid=$cid&offset=$newoffset\">$i</a> \n";
}

if ($offset>1) {
$prevoffset=$offset-$limit;
print "<a href=\"$PHP_SELF?cid=$cid&offset=$prevoffset\">$Prev</a> \n";
}

if ($numrows>($offset+$limit)) {
$nextoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?cid=$cid&offset=$nextoffset\">$Next</a><p>\n";
}
?>

Thanks again,
dast

[fitzbean]

I usually use

if (!$offset) { $offset=0; }

[dast1]

thats a better way of doin it, thanks