Client Detail Page
Im trying to make a detail page that has two tables joined and then filtered by the particular client. So they can download only there documents. Plz Help!
Thanx in advance. Eric
Im trying to make a detail page that has two tables joined and then filtered by the particular client. So they can download only there documents. Plz Help!
Thanx in advance. Eric
looks like you have set the orders.clientsID to hold the ID of the user from the clients.clientID column
try using the following recordset:
SELECT clients.client, orders.borrower, orders.county, orders.image, orders.loannumber, clients.username
FROM clients
INNER JOIN orders
ON clients.clientID = orders.clientID
WHERE clients.username = colname
then create a new variable in the variables section as:
name: colname
type: text
default value: -1
runtime value: $_SESSION['MM_Username']
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.