Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Displaying info from more than one table

Displaying info from more than one table

Thread began 12/01/2014 6:09 am by Mags | Last modified 12/02/2014 10:18 am by Mags | 1401 views | 7 replies

12/02/2014 4:04 amMags

Hi Jason

Thanks for the pointers - I've got it working using the following:

$paramSession_rsAccountants = "-1";
if (isset($_SESSION['JFBMicroID'])) {
$paramSession_rsAccountants = $_SESSION['JFBMicroID'];
}

and the recordset:

$query_rsAccountants = sprintf("SELECT *, COUNT(*)
FROM clients RIGHT OUTER JOIN accountants ON clients.AccountantID = accountants.AccountantID WHERE accountants.JFBMicroID = %s GROUP BY accountants.AccountantID, clients.AccountantID ORDER BY accountants.FirmName ASC",

It now displays the correct total number of clients for each accountant - except where there are no clients. If an accountant has no client, it's displaying 1 instead of 0. Any idea why this might be?

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.