How to select rows from database to html(or xml)-table which belongs to active user. User, after login to his account, needs to see html-table with his own data. Newest entry on top of the list. I need only to show columns "surname" and "films" of user1.
[table][tr][td]userID[/td][td]user_login[/td][td]name[/td][td]surname[/td][td]films[/td][/tr][tr][td]1[/td][td]user1[/td][td]John[/td][td]Malkovich[/td][td]Being John Malkovich[/td][/tr][tr][td]2[/td][td]user1[/td][td]John[/td][td]Malkovich[/td][td]Johnny English[/td][/tr][tr][td]3[/td][td]user2[/td][td]Steven[/td][td]Spielberg[/td][td]Indiana Jones[/td][/tr][/table]
Any examples are welcome, please.
