Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › display latest clients added

View all replies to this thread

display latest clients added

Thread began 4/15/2010 11:15 am by mr hankey | Last modified 4/16/2010 2:37 pm by mr hankey | 1490 views | 5 replies

4/15/2010 11:15 ammr hankey

display latest clients added

hi i have created this recordset:

SELECT *
FROM clients JOIN users ON clients.ClientUserID = users.UserID
ORDER BY clients.DateCreated DESC

however i only get 1 client returned when i click test yet there is 3 in there.

i did have at bottom:

LIMIT 5

but that made no difference, could someone tell me what i am missing to be able to display latest 5 clients added?

similar to display latest 5 orders in your powerstore demo but instead i want to use my latest clients added.

thanks for your help

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.