At 08:50 AM 9/1/2005, boclair wrote:
Content-Type: multipart/alternative;
X-Authentication-Info: Submitted using SMTP AUTH PLAIN at from [] using ID boclair at Thu, 1 Sep 2005 11:49:59 +0000

This is a multi-part message in MIME format.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

mysql 4.0.25
php 4.3.1

I seem to be unable to solve this problem without some help.

A webpage is to list all the clients in a  mysql " Client" table.  Each
client has an an allocated clid.

Those clients who are listed, identified by their allocated clid, in a
"Transactions" are to be highlighted in different ways according to
progress of the transaction, the progress being determined on whether
date values have been inserted into various fields.

Since mysql select joining the tables lists only the clients whose
appear in both tables.

I have been attempting to create a temporary table inserting the data
from "Client" and "Transactions"  and selecting from that but not
successfully yet. But is this the way to go about it.

The scale is an anticipated 1000 clients per month of which an
anticipated 800 will involve transactions


It sounds like you need an OUTER JOIN, which lets you fetch all the records from table A and table B that match, as well as the non-matching records from table B. The MySQL documents are a little confusing, here's a good article:

HTH - Miles
PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to