om the
command line in mysql with same user and password. SELECT and INSERTs
work via cgi with 'prepare' and 'execute'. I'm wondering if 'do' is
my problem.
--
Peter Fleck
University of Minnesota Cancer Center
[EMAIL PROTECTED]
www.cancer.umn.edu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rom grants is not selected (because it's not in the dates
table).
I can see one fix is to list each and every grant in the dates table.
Is there another way to write this so that it will work?
Thanks.
--
Peter Fleck
Webmaster | University of Minnesota Cancer Center
Dinnaken Office Bldg.
92
At 3:50 PM -0400 5/28/03, Keith C. Ivey wrote:
On 28 May 2003 at 14:17, Peter Fleck wrote:
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants,
dates
WHERE (grants.agency = "NIH-O" AND grants.grantid = dates.grantid)
GROUP BY grants.grantid ORDER BY dates.year
hen I remove the GROUP BY clause
but I get multiple listings for each grant.
I hope this is clear enough. I'm guessing there's a better way to do
this that works the way I want it to.
Thanks.
--
Peter Fleck
Webmaster | University of Minnesota Cancer Center
Dinnaken Office Bldg.
925 De
