I want to be able to get a set of records
get each record by row
then create html table rows with 2 cells per row and repeat but there can be 10 records or more.
any suggestion how to execute something like this.
You should probably read the examples in [man]mysql_query[/man] and [man]mysql_fetch_assoc[/man]. That will let you query a db and loop through the results. The [man]echo[/man] statement will let you output your html.
Have you tried googling PHP/MySQL tutorial?