Comparing Arrays

geogal

Hi All,

Is it possible to compare values in one array to values in another array? I have two different databases I need to match information on. One field is a timestamp, the other is a date field (this already may cause a problem). I need to pull the ID number from one array where the dates match.

The sticky part is that since I have two different field types, I'm guessing I'll need to use mktime(datefield) to convert to a timestamp, THEN compare to only the mmyydd portion of the timestamp field in the other database.

Does this make any sense? I can change the date field to a timestamp, if that matters, but I really only need the date to compare, since there can be only 1 ID number per day.

Hope I'm not making this more confusing than it is. I may need to pull away from this for a bit while I get my head around it.

Thanks for any assistance.

Geogal
🙂

dalecosp

$timestamp=array_1['timestamp'];
$date=strtotime(array_2['date']);
if (($date+(60*24*24))>$timestamp) {
// now you have a match!!

Should work, depending on the exact format of the date in your db...

geogal

Sorry for the late response. Thanks for the assistance.

dalecosp

Not a problem ... life is often like that, eh? 🙂

Hope it all goes well for you.

dalecosp