Re: REQ code help for case statement

George, Maritime Tel & Tel, or Aliant as they like to be known as now, has had its email servers screwed up all day. So if this has already been answered, just let me know. I also just had a look at the example in the MySQL manual and it's not a model of clarity. Well, maybe it is, but certainly not practical. Could you be a bit more specific about what you are trying to do? The difficult thing to get one's head around is that the CASE statement operates in the fields you are selecting, rather than in the WHERE condition. Miles At 08:17 AM 1/15/2002 +0000, George Pitcher wrote:

Hi all, Trying to move code into MySQL rather than php, but can't find any examples of what I want to do. I have a number of fields and want to be able to check a number of fields (most containing workflow dates or text) and return a 'message' for web display. The message will take the form of 'Status of record' followed by a date taken from the appropriate field (not always the same one). The example in the manual doesn't refer to field data at all but to numbers. How do I write the code to do this? I need to do this on two web pages, one for a single record and one which shows a list of records (each will display the 'message'. MTIA George, Edinburgh --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net