?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board
PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


 ?
New Topic??|??Go to Top??|??Go to Topic??|??Flat View??|??Search?
?Previous Message??|??Next Message
?Re: Jabbamonkey, reply to field exists...
Author:??(---.nyc.rr.com)
Date:???02-17-04 05:17

How do I plug the CASE statement into the query?....

Like this....

SELECT fname, mname, lname
FROM clients
CASE
WHEN photo_field is not null THEN photo_exists = true
ELSE photo_exists = false
END CASE
WHERE client=1

Or

Reply To This Message
?Newer Topic??|??Older Topic

?Topics Author? Date
?Jabbamonkey, reply to field exists...??new
bastien 02-16-04 15:49?
?Re: Jabbamonkey, reply to field exists...??new
Jabbamonkey 02-16-04 16:04?
?Re: Jabbamonkey, reply to field exists...??new
bastien 02-16-04 17:52?
?Re: Jabbamonkey, reply to field exists...??new
Jabbamonkey 02-17-04 05:17?
Go to Top??|??Go to Topic??|??Flat View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
????

Provided By
Phorum