select next row

Anon

I query the db to select a row. how can i select the next consecutive row?

thanks.

-jh

Anon

$sql= "SELECT * FROM $dbtable";

$query = mysql_query($sql);
while ($result=mysql_fetch_array($query)){
// This is your row loop
}

good luck

Anon

isn't there something simpler, like:

$myrow[++] or something like that?

Anon

Mark's solution is about as simple as it gets.

You might be thinking about $myrow[$i++], but then you'd have to worry about intializing $i, plus you'd have to get all the data about the your $result.

There are really only two ways to good ways to get information out of mysql. After your query the database [something like $result = mysql_query($my_query); ], you can use either:

mysql_fetch_row()
OR
mysql_fetch_array()

Read the php manual on these two functions to decide which you'd rather use.

Anon

I might be far off, even thinking about something else, but wouldn't the LIMIT come in us?

"... LIMIT $i, 1"

..thus increasing $i, you can move forward row by row...

// Thomasson