Retrieving Data

[Anon]

How would you go about getting whatever data somewhere in the middle of your MySQL database and print starting from this point and going down the list further instead of starting at the very top?

So far I've got:

$row = mysql_fetch_array($result);

Where do I go from here? I'm completely clueless from this point. Thanks to whoever can help.

[Anon]

use if and whiles statements. ie

while($row=mysql_fetch_array($result)){
if(flag is true or mydata from database is true?){
$flag = true;//to print data after finding your data from database afterwards

print $row["blah"];
}
}

[tomhath]

If you just want to page through the output, read the article about Next/Prev buttons on this site.

If you want to start in the middle for some other reason you could use mysql's LIMIT keyword on the SELECT.