[RESOLVED] show the next id's

Ethan22

I was told by some here I have to change what I'm doing to something else. So I have this that is showing the first id's and rows in order from a database:

$selectthesecolumns = "SELECT image, url, webname, description, id FROM `business` WHERE `id` >= $getrowsinorder ORDER BY `id` LIMIT 5";

and I'm setting a cookie for what's happening right now:

 $ookie = (isset($_COOKIE['t']) && intval($_COOKIE['t'])+1 : 1; 
setcookie("t", $ookie, time()+60*60*24*1825);

That cookies not right yet though I have to say what the cookie is incrementing up from, that's just an example getting me started.

I have it selecting id's but not the last id to help me with the cookie. What I need to know is and I'm not finding it in the php manual or google. I need to know how to grab the last database id row that is being shown now. Because I need to store that last database id that is being shown, so I can write some code for which next ids will be shown next after so much time. Please let me know, these are harder parts for me I need to know what the php commands are for. Thank you.

Ethan22

Thanks. There must be something that says $lastid =
To store it in some $lastid = the php store last id, prompt here.
Once I have the last id pulled, stored in a $lastid =
then I can have the cookie remember what the last id stored was.
So that on next page refresh the code will then show the next rows of items instead of the last onces showed. I just don't know the names of some of the php commands that will do some of these things. If I can get help with some of the names, I can try writing quite a bit of the rest already have.

cretaceous

lazy way : set the "last" id each time you iterate over the rows .. the last row will be the one that is stored

slightly more effort: get the number of rows returned in the result set
[ mysql_num_rows($result) ... if you are using mysql extension ]
increment a counter as you go through the rows like:
$i++;
when counter ==number of rows store that id..

Ethan22

Thank you lol. How will the number of rows it just pulled, allow the code to know which id's to show next doing it the way you said? Please let me know, thanks.

cretaceous

you said you wanted the last id of the set you go through - try either of the methods and see if it works for you

you didn't say you want to show the next ids, but I'm guessing that setting $getrowsinorder=$lastid
might do what you need
your description of what you want to do is not very clear!

if you show more code it should be easier to show..

Ethan22

Thank you very much for helping me I'm stumped on getting this last row id part, so that the code will show the next ones after so many seconds. People told me here I would need some cookie so the code would know the rows it showed last. I'll post it next after I get it all together for awhile.

cretaceous

yes I saw the other thread..
I think it would be better to keep your questions about it in the other thread, because the delay action is the key part to this

Ethan22

About cookies what I'll try to use, I have this so far. I'm showing 5 database rows right now, I want to show the next 5 rows every so many seconds when the web page is already open. That's all I'm trying to do. Let me know if something about what I just said didn't make sense or something I'm saying doesn't make sense, that's all I'm trying to do. I'm stumped on this last always showing the next ones after so many seconds, with the cookie.

$getrowsinorder = mysql_real_escape_string('id'); 
$selectthesecolumns = "SELECT image, url, webname, description, id FROM `business` WHERE `id` >= $getrowsinorder ORDER BY `id` LIMIT 5"; 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error());
//said this following cookie isn't right yet and because incrementing isn't right in following yet
$ookie = (isset($_COOKIE['t']) && intval($_COOKIE['t'])+1 : 1; 
setcookie("t", $ookie, time()+60*60*24*1825);

Are you saying this

$getrowsinorder = mysql_real_escape_string('id');

already counts the showing rows and get's the last id, or do I need to get the last row id another way? Thank you very much.

cretaceous

I assume you are stepping through $pullcolumns something like this:

while ($row=mysql_fetch_array($pullcolumns ))
{
   .. get the values and do something
   ..and add this line:
   $lastid=$row['id'];
}

as it steps through the rows $lastid has been set to the first row , then second row, then third row.. and at the very end it is set to the last row id
- this is the lazy method

how you place that lastid into in your redirect is another matter, but yes that then becomes the new value for:

WHERE `id` >= $getrowsinorder 
but this time you want simple greater than:
WHERE `id` > $getrowsinorder

Ethan22

Why here for help, not real good at this. Yes have it like this, missed that part real sorry about that I was so focused on fixing the top part.

$getrowsinorder = mysql_real_escape_string('id'); 
$selectthesecolumns = "SELECT image, url, webname, description,  FROM `business` WHERE `id` >= $getrowsinorder ORDER BY `id` LIMIT 5"; 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error()); 
//said this following cookie isn't right yet and because incrementing isn't right in following yet 
$ookie = (isset($_COOKIE['t']) && intval($_COOKIE['t'])+1 : 1; 
setcookie("t", $ookie, time()+60*60*24*1825); 

while ($column = mysql_fetch_array($pullcolumns)){
echo "<p><a href='$column[url]' >$column[webname]</a><span >$column[description]</span></p>";

I didn't know it was already pulling each separat id, that happened by total accident for showing the 5 id's in a row. I'm trying to figure out how to store the last showed row id, so then it will show the next 5. Unless there is a better way with this.

Ethan22

Thank you

WHERE id > $getrowsinorder

I'll try to see what my brain can get working with that.

Ethan22

That was rough took me all afternoon non stop. Now I know why having trouble with that last cookie, id, part, it is the real tricky part for me. This is what I muddled through and am stuck. At least I tried hard. I know it needs help, why I needed help. Please help, thanks a lot.

$getids = mysql_real_escape_string('id');    

$selectthesecolumns = "SELECT url, webname, description, FROM `business` WHERE `id` >= $getids ORDER BY `id` LIMIT 5"; 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error());
$asc = mysql_query("select `id` from $selectthesecolumns order by `ID` asc") OR die('This query not working: ' . mysql_error());  //will return the highest "id" number called this run?
$max = 5;// do I need another limit here to help with these cookies?
$kie = (isset($_COOKIE[$asc]) && intval($_COOKIE[$asc]) == $max)? intval($_COOKIE[$asc])+1 : 1;//Pretty sure this isn't right yet? No matter what the highest id is, if it equals 5 rows pulled then go to 1 higher number id?  

setcookie($asc, $kie, time()+60*60*24*1825); //then set the cookie with the last number id and amount of cookie days. 
$selectthesecolumns = "SELECT url, webname, description, FROM `business` WHERE `id` >= $getrowsinorder ORDER BY `id` LIMIT 5"; //I know this not right yet, then show the next 5 id's in order. 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error()); 

while ($column = mysql_fetch_array($pullcolumns)){ 
echo "<p><a href='$column[url]' >$column[webname]</a><span >$column[description]</span></p>";

Ethan22

And a closing bracket at the end
}
I seem to be stuck on how to get the last above to show the next 5 rows, after the last 5. Someone that knows much more about php than I do, since I don't know much php can probably see where my inexperienced errors are.

Ethan22

Seems like it needs something that says after the first 5 rows.. Whatever the last 5 rows were at any time, then show the next 5 rows from then on.

cretaceous

you need to split this into two tasks

complete the part where you get the five rows and the last id value

then either with a submit button in a form, or with a clickable page link make sure you can use that to get the next 5 values shown on your page

until you have that working, ignore the timer function

you should be able to get rid of the first set of myql queries - you don't need to do it all twice -that is just confusing you.

Ethan22

Thank you very much.

I need help with values and php can someone help me? It makes no sense that there is no more help with values after a lot of my extra work. Because shows I am not able to do them by myself so real obviously I need some help. I can't go to the lot of work for clickers and submit buttons that the code won't even be using, but thank you anyway. I'm just going to use a meta refresh for the time for this, for the next 5 rows to show. <META HTTP-EQUIV="refresh" CONTENT="60"> Thank you very much for anyone helping me.

Ethan22

I've been plugging away on this badly for some weeks straight why need some help.

Ethan22

$getids = mysql_real_escape_string('id');     

$asc = mysql_query("select `id` from $selectthesecolumns order by `ID` asc") OR die('This query not working: ' . mysql_error());  //will return the highest "id" number called this run? 
$max = 5;// do I need another limit here to help with these cookies? 
$kie = (isset($_COOKIE[$asc]) && intval($_COOKIE[$asc]) == $max)? intval($_COOKIE[$asc])+1 : 1; //Pretty sure this isn't right yet? No matter what the highest id is, if it equals 5 rows pulled then go to 1 higher number id?   

setcookie($asc, $kie, time()+60*60*24*1825);  //then set the cookie with the last number id and amount of cookie days. 
$selectthesecolumns = "SELECT url, webname, description, FROM `business` WHERE `id` >= $getids ORDER BY `id` LIMIT 5"; 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error()); 

while ($column = mysql_fetch_array($pullcolumns)){ 
echo "<p><a href='$column[url]' >$column[webname]</a><span >$column[description]</span></p>";

Ethan22

$getids = mysql_real_escape_string('id');

$selectthesecolumns = "SELECT url, webname, description FROM business WHERE id >= $getids ORDER BY id LIMIT 5";
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error());

//This next group here is where things say the problem is like thought. starting with it doesn't like this first line.

$asc = mysql_query("select `id` from $selectthesecolumns order by `ID` asc") OR die('This query not working: ' . mysql_error());  //will return the highest "id" number called this run? 
$max = 5; ;// do I need another limit here to help with these cookies? 
$kie = (isset($_COOKIE[$asc]) && intval($_COOKIE[$asc]) == $max)? intval($_COOKIE[$asc])+1 : 1; //Pretty sure this isn't right yet? No matter what the highest id is, if it equals 5 rows pulled then pull the next 5 rows
setcookie($asc, $kie, time()+60*60*24*1825); //then set the cookie with the last number id and amount of cookie days

while ($column = mysql_fetch_array($pullcolumns)){
echo "<p><a href='$column[url]' >$column[webname]</a>  <span >$column[description]</span></p>";}

Ethan22

I got that fixed with this following, no error messages:

$getids = mysql_real_escape_string('id');     

$selectthesecolumns = "SELECT url, webname, description FROM `business` WHERE `id` >= $getids ORDER BY `id` LIMIT 5"; 
$pullcolumns = mysql_query($selectthesecolumns) OR die('Error pulling a database column: ' . mysql_error()); 
$asc = mysql_query("select `id` from `business` order by `ID` asc") OR die('Problem with this query: ' . mysql_error()); 
$max = 5; // do I need another limit here to help with these cookies? 
$kie = (isset($_COOKIE[$asc]) && intval($_COOKIE[$asc]) == $max)? intval($_COOKIE[$asc])+1 : 1; //Pretty sure this isn't right yet? No matter what the highest id is, if it equals 5
setcookie('$asc', $kie, time()+60*60*24*1825); //then set the cookie with the last number id and amount of cookie days. 

while ($column = mysql_fetch_array($pullcolumns)){
echo "<p><a href='$column[url]' >$column[webname]</a>&nbsp;&nbsp;<span >$column[description]</span></p>";}

Now I'm back to the cookie again the part I have the most trouble of all figuring out myself. I put this following in so it would show me what cookie
and also id is showing currently on page refresh. It is saying the first id is the only one going into the cookie at all times. The only database id caught by the above code is only '1' at all times, the first database row only. It is not going on to the next 5 rows on next page refresh the way I have these cookies currently. Hope someone can help me with these cookies, thank you very much.
<?php
// Print a cookie
echo $_COOKIE[$getids];
?>