[RESOLVED] Cookie refreshing again and again...?

[Heatmizer20]

So I have to apologize first. After marking my last question resolved, i realized one last problem with the code. The Code is for a drop down box to sort a result.

The new problem:
I can sort everything perfectly fine, and the sorting continues and holds to the next pages.
But if you sort another time after the first sorting, it only does it on the first page, and keeps the first sort information on the following pages. I thought that this code is holding the cookies of the new variables, and would refresh with each new sorting, but im wrong. it holds the cookies once and keeps them, not refreshing each time.

What did i Missing?

<?php
setcookie ("limit",$limit);
setcookie ("sortby",$sortby);
setcookie ("listby",$listby);
?>

<form action="" method="post">

<select name="limit" id="limit">
  <option>Choose</option>
  <option value="2">2</option>
    <option value="4">4</option>
    <option value="6">6</option>
  </select>

  <select name="sortby" id="sortby">
    <option value="make">Choose Selection</option>
    <option value="price">price</option>
    <option value="year">year</option>
    <option value="make">make</option>
  </select>
  <select name="listby" id="listby">
    <option value="ASC">Choose List Order</option>
    <option value="DESC">Z to A</option>
    <option value="ASC">A to Z</option>
  </select>

  <input name="submitsort" type="submit">
</form>

<?php

$user = "me";
$pass = "my-password";
$server = "localhost";
$db =  mysql_connect("$server","$user","$pass");
$table = "my-data";
mysql_select_db("$table",$db);
$result = mysql_query("SELECT * FROM Listing", $db);


$prevLink = "< Previous |";
$nextLink = " | Next >";
$numresults =mysql_query("select * from Listing");
$numrows = mysql_num_rows($numresults);

if (!$id) {
if (empty($offset)) {
   $offset=1;
}

if (!isset($_COOKIE['make'])) { 
$sortby = 'make';  

} 

if (!isset($_COOKIE['listby'])) {
$listby = 'ASC'; 
}

if (!isset($_COOKIE['limit'])) {
$limit = 4;
}

if (!empty($_POST['sortby'])){
     $sortby = $_POST['sortby'];
	 }
if (!empty($_POST['listby'])){
     $listby= $_POST['listby'];
}
if (!empty($_POST['limit'])){
     $limit = $_POST['limit']; 
}   

$result = mysql_query("SELECT * FROM Listing ORDER BY $sortby $listby LIMIT $offset,$limit", $db);
    echo "<table width=\"590\" border=\"2\" cellspacing=\"2\" cellpadding=\"0\"><tr><td>\n";
	echo "<table border\"1\" cellspacing=\"0\" cellpadding=\"5\" align=\"center\">\n";
		echo "<td>Photo</td><td>Description</td>\n";
	echo "<td>Summary</td></tr>\n";

while ($myrow = mysql_fetch_array($result)){

$make_0 = $myrow["make"];
$model_0 = $myrow["model"];
$price_0 = $myrow["price"];
$id_0 = $myrow["id"];
$year_0 = $myrow["year"];
$description_0 = $myrow["description"];
$image_0 = $myrow["image"];

printf ("<tr><td><p></p>&nbsp <p><img src=\"/images/$image_0\" alt=\"\" height=\"120\" width=\"160\" border=\"0\"></p>&nbsp &nbsp<p></p></td>\n");
printf ("<td><a href=\"pagesum.php?id=%s\">$make_0 &nbsp $model_0</a>&nbsp;($year_0)<br><br>\n", $myrow['id']);
printf  ("$description_0 &nbsp; <a href=\"pagesum.php?id=%s\">more details</a></td><td>&nbsp $price_0 <br></td>\n", $myrow['id']);
}
echo "</table>\n";
echo "</table>\n";
}


if ($offset>=$limit) {
    $prevoffset=$offset-$limit;
	print "<a href=\"$PHP_SELF?offset=$prevoffset\">$prevLink</a>&nbsp: \n";
}
$pages=intval($numrows/$limit);

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

if (!(($offset/$limit)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">$nextLink</a><p>\n";
}
?>

Again, im sorry for the repeating thread.

thanks
-JB-

[Heatmizer20]

Anyone have any suggestions???

thanks,
-JB-

[Heatmizer20]

Anyone?????? 🙁

[Heatmizer20]

I tried Bastiens suggestion from [thread=10309825]Here[/thread] , which was to use a hidden form field instead of cookies, but i had no luck with that. This was the suggestion code:

 if (!$id) {   

if (empty($offset)) {   

   $offset=1;   

}   

//defaults for 
$sortby = 'make';  

$listby = 'ASC';  

$displayperpage = 10;  


if (!empty($_POST['sortby'])){  

  $sortby = $_POST['sortby'];  

}  

if (!empty($_POST['listby'])){  

  $listby= $_POST['listby'];  

}  

if (!empty($_POST['diplayperpage'])){  

  $diplayperpage= $_POST['diplayperpage'];  

}  

$sql = "SELECT * FROM Listing ORDER BY $sortby $listby LIMIT $offset,$diplayperpage";  

$result = mysql_query($sql, $db);  

    echo "<form action=".$_SERVER['PHP_SELF']." method='post'> 
              <input type='hidden' name='sortby' value='$sortby'>   

              <input type='hidden' name='listby' value='$listby'> 
              <input type='hidden' name='diplayperpage' value='$diplayperpage'>"; 

echo "<table border\"1\" cellspacing=\"0\" cellpadding=\"5\" align=\"\">Summary<br>\n";  

while ($myrow = mysql_fetch_array($result)){   
...   

echo "</form>";  

Does anyone know if there a different approach to this that might work? :bemused:
thanks,
-JB-

[Heatmizer20]

*Bump

[Heatmizer20]

After a lot of trial and error... reading things that i did not understand and slowly putting the puzzles together, i figured out what my problem was.

I was approaching my problem with the wrong solution. I was trying to keep my sorting the information and hold it to the following pages. I thought that the cookies needed to be set to achieve this, but i was wrong. there was another way. THE RIGHT WAY

here was were the problem was...

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

if (!(($offset/$limit)==$pages) && $pages!=1) { 
$newoffset=$offset+$limit; 
print "<a href=\"$PHP_SELF?offset=$newoffset\">$nextLink</a><p>\n"; 
} 

It was in this line that i had the error. I created buttons that would change the $sortby variable: example

<a href=\"$PHP_SELF?sortby=type\">Type</a>
<a href=\"$PHP_SELF?sortby=make\">Make</a>
<a href=\"$PHP_SELF?sortby=model\">Model</a>
etc.....

and by simply putting $sortby into the line, I got exactly what i was looking for.

it should have looked like this.

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

}
if (!(($offset/$limit)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
}
if ($newoffset<=$limit){
print "<a href=\"$PHP_SELF?offset=$newoffset&sortby=".$sortby."\">$nextLink</a><p>\n";
} 

I hope this helps anyone that was or is having the same problem i was having.