nextrow-problem

cassius

I'm trying to add a "next event"-link om my website that holds a lot of different party-events in my area.

My problem is that I use an autoincrement-id in my event-table, and therefore the next event doesn't always hold (currentID+1) as its eventID. What I'm trying to say is that the next event after this event: showevent.php?eventid=14 could be showevent.php?eventid=18....

In ASP I know there is such a thing as rs(recordset).moveNext or something like that, and my Question is if there is an option similar to this in php/mysql....

...I know I can solve my problem by doing new selects on each presence of showevent.php

"SELECT * FROM Events WHERE eventID > currentID ORDER BY eventID ASC LIMIT 1";

but I wonder out of curiousity(and effeciency) if there is an easier way to do this??

Help would be much appreciated.

barand

All the mysql_fetch_xxxx() functions do a 'MoveNext' and get the next row of data.

See [man]mysql_fetch_row[/man] etc.

cassius

I am aware of that, I think I just wasn't good enough to make myself clear about my problem/issue...I solved it doing new SELECT queries each time showevent.php had an eventid, so I guess I can mark this tread resolved unless someone have a better solution...

I don't mean to do this:

$sql =  "SELECT * FROM Bla WHERE bla='balbal'";
$var = mysql_query($sql);
while($row = mysql_fetch_array($var, MYSQL_ASSOC){
   echo "<a href='showevent.php?eventid=".$row['eventID']."'>Link_to_next_event</a>";
}

If anyone knows a mysql/php-command to move to the next row in the result set of a mysql_query() regardless of the contents/value(ex eventID) of the next row, I would like to know....

or maybe I just didn't understand what you meant barand
???

helz

i dont know about the view.next or whatever, will take a deeper look into php.net later...

i think you can do this, which should work:

if (empty($_GET['limit'])) {
$limit = 1;
}
$sql = "SELECT * FROM Events WHERE eventID > currentID ORDER BY eventID ASC LIMIT $limit";
// link can post to:
echo "<a href='$PHP_SELF?limit=".$limit++."'>Next Article</a>";