par15h

ah thank you, i do not need to show all the rows no, my initial thought is just to have scattered information from say row 3 on the page somewhere,... then show another row on another part of the page.. in another part of the design on the page. im not to good with php, but with the information i have posted could you possible help me out and write the code i would need to show just row 2, and if i wish to show row 3 on another part of the page further down the design of the site.. what i would need to write? thank you for reply and the help!

ok i am having a small problem, im sure its easy to over come and i still have not been able to manage it. so i have Recordset1 = database for composers now i want to show the 2nd record, from the databse composers, on the page freely, without having to use tables - Name {Recordset1.Name} - Age {Recordset1.Age} - Date {Recordset1.Date} - Time {Recordset1.Time} - Place {Recordset1.Place} to show the first record at the moment, it is of course: <?php echo $row_Recordset1['Name']; ?> = [b][i]"John"[/i][/b] now say for instance i wanted to show the second record within the database on the page? Record 1 = [b]John[/b] 53 12/01/06 13:45 London Record 2 = Paul 65 15/12/05 14:56 Kent i want to show "Paul" not [b][i]"John"[/i][/b] does anyone know how to go about this? or needs anymore information? please do help! thank you