Miscellaneous > Programming & Networking

PHP scripts failing to use SQL functions

<< < (2/2)

Refalm:
Check if $time and $date are in the right format. Sometimes the values for date are actually month-day-year. And maybe time input is without seconds. Just check the database.

You also need put strings between '

reactosguy:

--- Quote from: Refalm on  2 October 2010, 00:05 ---Check if $time and $date are in the right format. Sometimes the values for date are actually month-day-year. And maybe time input is without seconds. Just check the database.

You also need put strings between '

--- End quote ---

The database uses a DATE in one of the columns of the tables. It's usually interpreted as Year-Month-Day.

Also, TIME column does do seconds, if I remember correctly.

EDIT: I changed both of them to VARCHARs so there shouldn't be many new problems.

Navigation

[0] Message Index

[*] Previous page