Thanks! so much for a prompt reply. My question is...
I have entered dates Mondays & Thursdays only for the time being in DATE format yyyy-mm-dd...how do I get MySQL db to populate my table with these Mondays & Thursdays only in the first place...into the drop down list...I guess something like capturing todays date from MySQL DB should do the trick...?? how do i do that...also I want to display only future dates...meaning I dont want to display Monday,10/04/2004 since its already has passed...so current list of Mondays & Thursdays for the Rest of the year only should be displayed...
Thanks! Again. I am a newbie to PHP & MySQL DB. My guess is the best way...is to generate...them through...php ...anyways can u pls look at my proj descrip & help me know...what is the best way to do it & how to? I would really appreciate your Help!.
This is a simple delivery of a variety of foods to each home
I gave you a detailed descrip of the whole application...I will really
appreciate If you could help me with this one.
else redirect to screen 1 for a correct password.
I have done this Log in Screen...
Homes: drop down list of Homes 1 to 25
Delivery Dates: Mondays and Thursdays only(This drop down list should
contain only Monday, 10/11/2004 (MM/DD/YYYY format and also similarly
for Thursdays).How to get these dates in a drop down list? My guess is
it is good to do a client side generation of dates...If so how do I do that?
Goods will be delivered corresponding Monday only If atleast an order
is placed by previous Friday 12 PM (for Ex 10/08 for a delivery of
10/11) likewise will be delivered Thursday only If an order is placed
before previous wednesday 12 PM.
Once a User chooses let's say Home1 and 10/11/2004. If a record
already exists for this combination it should populate the Info in
a form(Screen 3) from MySQL Database.
Homes should be grabbed from a Homes Table & Delivery Dates from Orders Table .
There should be a client side validation for MAX num of foods one can order
at any given time for each Home...lets say MAX limit is 5 gallons of milk for
each home for one order/transaction for a given date. So, If someone tries
to enter 6 in quantity then it should flag sorry you can enter only upto 5.Usually MAX qty per food item is unique to a food item & its home. For example for Home1 5 gallons of skim milk, 3 gallons of chocolate milk & 3 loafs of bread are MAX qtys for these food items for Home1.
If a record like above does not exist A New Record should be created.
If a record like the above appears when a Home1 and 10/11 is chosen
from drop down lists then user should be able to modify these quantitys
and hit submit button.
After that a corresponding message like a a NEW order has been placed or
Your Order has been modified should appear.
Also in screen 1: a Link for Report should be provided.When one clicks
on Report again...a password should be asked for...or we can enter
report in password in screen 1 which will take us to a Report.
Essentially report would be...
A summary of Foods Delivery Report By Htore for a particular day with Grand total
of each food quantity reqd.
Goods Delivery Report
Reg Milk 3
Skim Milk 3
Choc Milk 3
Likewise for each Home...
and a Grand Total of some thing like 100 candy boxes
100 Cereals etc...