search of mySQL database

[rosegarden]

I am relatively new to PHP and mySQL and programing in general.

I am trying to figure out how to search my mySQL database and only show 1-10 and then 11-20 etc.

I read a little about 'limit' but it didn't say how to move on to 11-20 etc.

My search works now by using 'like' and chooses its comparison from a specific field with keywords that I enter.

Thank you in advance

[akozlov]

limit <from>,<length>

[modify]

You could put a link @ the bottom of your script like this: <A HREF='search.php?sterm=$term&lowval=1&highval=11'>Next 10</A>.

Then, in the top of your php script, before you do your select query, increment both $lowval and $highval by 10. Should be pretty close to working then.