[PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread Scott Miller 
Hi,

I have checked the recent list archives and looked up various PHP functions.
I know what I want should be simple but, apparently not simple enought for
me.



I have a mysql database that has a date field and a time field.

I want users to be able to enter a date and a time in text boxes on an html
form and have them end up in the database.

I am having no trouble connecting to the database and running queries
against the database but I cannot get the dates and times into the database.

Of course I also want to search for the database for an entered date on
another form.

I am not having trouble with SQL statements or mysql_connect() or anything
like that just taking a date as a string from a text box and getting into a
DATE field in a mysql database.

What obvuios thing did I miss?  Note I am not using the system date or time
stamp, these are entered dates.


Regards,

Scott

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread Jay Blanchard 
[snip]
DATE field in a mysql database.

What obvuios thing did I miss?  Note I am not using the system date or
time
stamp, these are entered dates.
[/snip]

You're using a DATE field in the MySQL database. MySQL requires an ISO
formatted date unless you manipulate it, such as 2004-09-14
http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread John Holmes 
From: Scott Miller [EMAIL PROTECTED]
I have a mysql database that has a date field and a time field.
I want users to be able to enter a date and a time in text boxes on an 
html
form and have them end up in the database.
Code examples would be good here. Either way, the format for a DATE field is 
MMDD or '-MM-DD' and the format for a TIME field is HHMMSS or 
'HH:MM:SS'. Make sure what you're trying to stick in the database is in that 
format. If you want to accept another format in your text fields, then 
you'll need to use date(), strtotime(), mktime(), explode(), etc to format 
it this way.

You really just need one DATETIME or TIMESTAMP field, though... there's 
reason to keep these values in two separate fields if they are related to 
the same event. It'll make searching down the road easier.

SELECT * FROM events WHERE datetimecolumn BETWEEN NOW() AND INTERVAL + 30 
DAY;

SELECT * FROM events WHERE datetimecolumn BETWEEN 20040901 AND 20040930;
etc...
---John Holmes... 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php