Okay, I give up. What's the answer?

[Ifa]

Why varchar(100) on the day, month and year?

[craygo]

That is just showing you what my table is structured like. Has nothing to do with the code. DO NOT INCLUDE IT ON YOUR PAGE!!

Well I keep asking how the fields are structured and I get no answer so I set them as varchar for worst case senario.

Ray

[Moron]

[quote author=craygo link=topic=104649.msg417998#msg417998 date=1155911724]
That is just showing you what my table is structured like. Has nothing to do with the code. DO NOT INCLUDE IT ON YOUR PAGE!!

Well I keep asking how the fields are structured and I get no answer so I set them as varchar for worst case senario.

Ray
[/quote]

I see. Thanks. I first tried it with only the second section and it tossed a syntax error. I'll take another crack at it.

[akrytus]

Really that last post by craygo should work.  No problem.

Ohh sorry about the error I posted originally.

[quote]also this does not look right


Code:
$day=$RESULT['Lmo']."/".$RESULT['Lda']."/".$RESULT['Lda'];
  $day_timestamp=strtotime($day);
shouldn't it be

Code:
  $day=$RESULT['LYR']."/".$RESULT['Lmo']."/".$RESULT['Lda'];
  $day_timestamp=strtotime($day);[/quote]