[RESOLVED] PHP Dates & SQL (simple question)

h4x0rmx

I have a table that looks like this:

					DATE			TIME		TIME
id *	punch_id *	account *	date			time_in		time_out
2342	191913		testing2	4/29/2009 12:00:00 AM	13:51:00	13:59:00
2341	191912		testing		4/3/2009 12:00:00 AM	01:01:00	12:02:00

and an array full of id's and dates that look like this:

Array ( [id] => 2342 [start_date] => 2009-04-29 13:51:00 [end_date] => 2009-04-03 13:59:00)

I need to write a function that checks if the info in the array already exists in the database.
So with the info in the array, I need to know if I have a record on the database with the same id, same date and same time_in and time_out
so I need
id = array['id']
date = array['start_date']
time_in = array['start_date']
time_out = array['end_date']
(The dates on array['start_date'] and array['end_date'] will always be the same, but the times will change)

As you can see the date/time format in the array are different than those in the DB... I'm a little confused on how I should pull out and format the info on my array when making the query...
Any suggestions?

Krik

First split up the time and date values and use the [man]strtotime/man [man]date/man function to reformat the date to be the same format as the database

$my_array = array("id" => "2342", "start_date" => "2009-04-29 13:51:00", "end_date" => "2009-04-03 13:59:00");
$startdate = explode(" ", $my_array[start_date]);

$my_array[start_date] = date("n/j/Y", strtotime($startdate[0])) . " 12:00:00 AM";
$my_array[start_time] = $startdate[1];

$enddate = explode(" ", $my_array[end_date]);

$my_array[end_date] = date("n/j/Y", strtotime($enddate[0])) . " 12:00:00 AM";
$my_array[end_time] = $enddate[1];

that will give you an array like

Array (
    [id] => 2342
    [start_date] => 4/29/2009 12:00:00 AM
    [start_time] => 13:51:00
    [end_date] => 4/3/2009 12:00:00 AM
    [end_time] => 13:59:00
)

and then just make your query compare the array values to the database

$myqry = "SELECT * FROM `mytable` WHERE `id`=".$my_array[id]." AND `date`=".$my_array[start_date]." AND `time_in`=".$my_array[start_time]." AND `time_out`=".$my_array[end_time];

$qryres = mysql_query($myqry);

$numrecs = mysql_num_rows($qryres);
if ($numrecs == 0) {
    //insert code here
}

Hope that helps. Do be warned I just hand typed that all so there could be typo's or syntax errors. But it should point you in the right direction

h4x0rmx

@
Thank you!
I really appreciate your help!