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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
