Convert numbers into Date

[web_master]

Hi,

 

I got in dBase table columns:

 

year, mont, day

 

Year is INT(4)

Month is INT(2)

Day is INT(2)

 

 

<?php 
$query_return = mysql_query("SELECT * FROM `r_monday` ORDER BY `r_monday_id` DESC");

// Check query
if(!$query_return){
	print mysql_error();
	exit;
}

// Request query
while($request = mysql_fetch_array($query_return)) {
$Date = $request['r_monday_year'].". ".$request['r_monday_month']." ".$request['r_monday_day']."."

if(date("Ymd") > $Date) {

  $DatePrint = "";

}elseif(date("Ymd") < $Date) {
  $DatePrint = "$Date";
}
?>

 

I think I must to convert r_monday_year, r_monday_month, r_monday_day into date format to work this script, but i dont know how can I do this?

 

Thanx for help in advanced

 

T

[Mchl]

If you're working with dBase, why are you using mysql_query ?

[web_master]

putting date into database is not a datetime from Dbase - its users choose he choose the year, month and day

[Mchl]

Yeah... I was in mood for a joke, but you didn't get it

http://en.wikipedia.org/wiki/DBase

 

You should be comparing timestamps. Take a look at strtotime

[web_master]

Sorry, Dbase is a database, MySQL, SORRRYYYY!