moving to a record in MySQL

[d2kagw]

Howdi,

I was just wondering how I move to a record in a script.
im trying to do something like this:

open database
count records - record count = $x
move to record ($x / 2)

I know it can be done, but im a bit slow !

thanks

-az