PHP and MS Access Dates prob on SELECT

[Anon]

Hi all,

I need to select data held by date from an MS Access db, however my PHP and Access time formats do not match and I end up with a datatype mismatch when I use the following SQL statement:

SELECT * FROM newevents WHERE edate = '$etype' and etype = '$etype'

I've formated my time string to US format too, but this doesn't help.

Does anyone know how to format the timestring into a format that Access will like?

Matthew

[Anon]

I see you're comparing your edate to etype in your sql. I'll assume that is just a typo.

I don't have any code here with me to check, but Access usually wants the date to be enclosed with pound signs (#). So you would use something like:

Where edate = '#$edate#' and .......

$edate should be in a mm/dd/yy format