Sorry, I need help with a date function

peanutgallery83

I hate to do this, but I've searched this forum for the better part of 2 hours, and looked through the PHP guide dealing with dates and time functions, but for the life of me I cannot figure out how to do what is probably a VERY simple function. I'm really hoping someone can help me!

What I've got is a date function stored in a field called cal_date in a table. The format is standard Date format: yyyy-mm-dd

Anyways, I have it set up all nifty to enter the data in, BUT i need to be able to edit this date using drop downs (similar to how it is entered).

What I really want to do is very simple, break the date (yyyy-mm-dd) into 3 variables:

$cal_year
$cal_month
$cal_day

I can handle it from there, but for the life of me I don't know how to get from my database query, broken down into those 3 variables.

$sql ="SELECT cal_id, cal_date, date_format(cal_date,'%m-%d-%Y') AS cal_date_display, cal_time, cal_type,  cal_name,  cal_location,  cal_coordinator, cal_telephone,  cal_instructor,  cal_registration FROM $table_name WHERE cal_id = '$_GET[id]'";

$result = @mysql_query($sql,$connection) or die(mysql_error());

Any help will be much appreciated. This has been a HUGE project, and I'll be darned if this one little thing isn't the ONLY problem I haven't been able to solve on my own....rather annoying!

paulnaj

Hi there,

Here we go ...

<?php
$sql ="
SELECT	YEAR(cal_date) AS cal_date_year
	, 	MONTH(cal_date) AS cal_date_month
	, 	DAYOFMONTH(cal_date) AS cal_date_day
FROM	$table_name 
WHERE	cal_id = '$_GET[id]'
";

$result = @mysql_query($sql,$connection) or die(mysql_error()); 
?>

Paul 🙂

peanutgallery83

Thank you very much! As I was afraid of...the answer...once seen...would be horribly obvious!

Ah, the joys of learning PHP. :queasy: :rolleyes:

Thanks again.

Norman_Graham

Hi Peanut

Stop apologizing. This forum is here to exchange knowledge. Anyone who demonstrates a little effort on their part (try some code first) is welcome to ask questions.

Merry Christmas

Norm