Content-Type: multipart/alternative; boundary="------------070700030402040702060708" X-Authentication-Info: Submitted using SMTP AUTH PLAIN at omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep 2005 11:49:59 +0000 This is a multi-part message in MIME format. --------------070700030402040702060708 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 Louise --------------070700030402040702060708 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> <font size="-1"><font face="Comic Sans MS">mysql 4.0.25<br> php 4.3.1<br> <br> I seem to be unable to solve this problem without some help.<br> <br> A webpage is to list all the clients in a mysql " Client" table. Each client has an an allocated clid.<br> <br> 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.<br> <br> Since mysql select joining the tables lists only the clients whose appear in both tables.<br> <br> 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.<br> <br> The scale is an anticipated 1000 clients per month of which an anticipated 800 will involve transactions<br> <br> Louise <br> <br> <br> </font></font> </body> </html> --------------070700030402040702060708-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
