How can one select a row from an SQL table in n-times?

Question

Using two tables in the same database

Answer 1

What you mean exactly? You can select a row with usual query like:
SELECT * FROM tablename WHERE id=1
Or you need something else?

Answer 2

Why you need 10 similar selects? You can select and store data in variable if you need 1 row or select multiple rows with one query and store it in array. Lot of consequent small queries is not proper way when working with SQL.

Answer 3

I meant; selecting a row in 10times and proceed executing same query to another row.
thanks Jeth.