View unanswered posts | View active topics It is currently Tue Jul 05, 2022 5:39 pm

Reply to topic  [ 1 post ] 
 Field Advice 
Author Message
Junior Member

Joined: Tue Feb 05, 2008 8:01 pm
Posts: 1
Post Field Advice
Good evening,

I am a newbie trying to build a simple time booking application that can do the following:

A user comes onto the site and wants to see if the photographer is available on a certain date. They enter their date, the php queries the database to see if the photographer has entered that date in his already booked dates list. If the date is available, the application returns a success message and provides a form for the user to fill out which ONLY emails the photographer, it does NOT enter or reserve a date into a database. If the date is taken, then the application gives a "sorry" message.

So now my questions. What fields do I need in my MySQL database for this to work. I am not dealing with times, just days. So a month, a day number and a year. Do I just use one field? Or do I use a field for each of those things plus a unique id number.

Thanks for the time you have taken to read this, any help would be much appreciated.

Tue Feb 05, 2008 8:13 pm
Report this post
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
© Copyright 2003-2008 The ultimate PHP Editor and PHP IDE site.