Problem figuring out best method of summing multiple date values....
Posted by:
cdubks88
Date: August 13, 2004 02:36PM
I'm running MySQL 3.23.54a (methinks) on Yellow Dog Linux 3.0 and I have several php pages that are working properly inserting, editing, deleting and mailing form data correctly.
I have another issue that I need help resolving. There is a need to show several tour dates and then have the SUM() of the tix field be done FOR EACH $tourdate......of which there are many and display the results on a formatted page in a table with two columns - $tourdate and $availtix ($availtix = 25 - $num_tix).
I just don't know how to do this in a good way, because as I've tried to sort any logic of it, I guess I'm having a hard time seeing where there won't need to be several query statements.......but I'm CERTAINLY no pro; in fact, quite the polar opposite...so any help is greatly appreciated. I'll be happy to pastebin the code I have so far if it would help.....:-)
Thanks,
Chris
Subject
Written By
Posted
Problem figuring out best method of summing multiple date values....
August 13, 2004 02:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.