Don, thank you. The SELECT statement worked perfectly just as you
suggested. Though the books I have on MySQL are pretty good, trying
to figure more and more esoteric statements out is a bit of a
challenge, even just in terms of syntax.
Nelson
>
> > In looking via SELECT * FROM tickets, the DATE fields are NULL if
>> nothing is actually entered into them.
>>
>>
> > I've tried SELECT COUNT(*), COUNT(ISSUED IS NULL) as notissued... etc
>>
>
>
>not tested - try:
> select count(*), sum( IF (ISSUED IS NULL,1,0)) ...
>
>Don Read [EMAIL PROTECTED]
--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php