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.
-
☆ A M B ☆
- 3,112 Posts
it means you need a snippet to select data and show them in the MODx page.
Depends on how good is your coding skill, you can create a simple Snippet with MODx API, or try to find the existing one from the MODx’s extra repository.
Rico
Genius is one percent inspiration and ninety-nine percent perspiration.
Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!
www.virtudraft.com
Security, security, security! |
Indonesian MODx Forum |
MODx Revo's cheatsheets |
MODx Evo's cheatsheets
Author of
Easy 2 Gallery 1.4.x,
PHPTidy,
spieFeed,
FileDownload R,
Upload To Users CMP,
Inherit Template TV,
LexRating,
ExerPlan,
Lingua,
virtuNewsletter,
Grid Class Key,
SmartTag,
prevNext
Maintainter/contributor of
Babel
Because it's hard to follow all topics on the forum, PING ME ON TWITTER
@_goldsky if you need my help.
-
☆ A M B ☆
- 3,112 Posts
Rico
Genius is one percent inspiration and ninety-nine percent perspiration.
Thomas A. Edison
MODx is great, but knowing how to use it well makes it perfect!
www.virtudraft.com
Security, security, security! |
Indonesian MODx Forum |
MODx Revo's cheatsheets |
MODx Evo's cheatsheets
Author of
Easy 2 Gallery 1.4.x,
PHPTidy,
spieFeed,
FileDownload R,
Upload To Users CMP,
Inherit Template TV,
LexRating,
ExerPlan,
Lingua,
virtuNewsletter,
Grid Class Key,
SmartTag,
prevNext
Maintainter/contributor of
Babel
Because it's hard to follow all topics on the forum, PING ME ON TWITTER
@_goldsky if you need my help.
