current date

lucashii

I have a database where there are two tables which is movie and movie_ticket tables. movie table holds the movie_id and movie_title and movie_ticket tables hold the movie_id and date. I wish to display only movies which is has not expire from the current date.Is that possible?thanks~

SELECT * FROM movie,movie_ticket WHERE movie_id = ticket_id ORDER BY date;

liquorvicar

Sounds like you need

 WHERE date_field>=CURDATE()

MySQL date functions

obsidian

lucashii wrote:
I have a database where there are two tables which is movie and movie_ticket tables. movie table holds the movie_id and movie_title and movie_ticket tables hold the movie_id and date. I wish to display only movies which is has not expire from the current date.Is that possible?thanks~

SELECT * FROM movie,movie_ticket WHERE movie_id = ticket_id ORDER BY date;

what datatype are you storing the date as? if it is a DATE or DATETIME field, the suggestion above will work great for you. otherwise, you may need to come up with another solution.

lucashii

thanks i got it working now~

now i want to validate the current time with the time i store in my database. I got my time from my database with fetch_assoc which is in HH:MM:SS format.How would i get the $currentTime from my local machine and validate it with $timea?Thanks~~

$timea = from my database in HH:MM:SS format

if ($timea < $currentTime)

obsidian

lucashii wrote:
thanks i got it working now~

now i want to validate the current time with the time i store in my database. I got my time from my database with fetch_assoc which is in HH:MM:SS format.How would i get the $currentTime from my local machine and validate it with $timea?Thanks~~

$timea = from my database in HH:MM:SS format

if ($timea < $currentTime)

the easiest way would be to change them both to UNIX timestamps and go from there. something like this should do the trick:

$timea = "12:14:43";
$oldTime = strtotime("today $timea");
$nowTime = mktime();

if ($oldTime < $nowTime)
  // fetched time is passed
else
  // fetched time has not passed

lucashii

hiya thanks obsidian it work now i only need to validate the date but the curdate() only works in mysql~

I need to get the current date to validate against the date in my db which is in YYYY-MM-DD format.Any help would be appreciated~

liquorvicar

date('Y-m-d');

will give you the current date in YYYY-MM-DD format.
PHP's date function is really powerful, read up on it in the manual.