Re: search of data base - again

On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner <jim.giner@albanyhandball.com> wrote: > > ""Jim Giner"" <jim.giner@albanyhandball.com> wrote in message > news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... >> =============== >> Martijn & Jim - >> >> Is it just the date that is the problem? >> >> Yes. >> >> Tru dat.  But mySql doesn't want the dashes embedded.  The format string >> should be "Ymd" instead. >> >> That's what I am doing.  No luck. >> >> Ethan >> >> ***** >> You're using a format with just Ymd in it (no dashes)?  Can you post >> *just* the query as it is looks in your php code? >> >> >> > While waiting - I looked at your code again.  What is the (greater than) > symbol doing in front of your $Date var? >> > Date) VALUES(null, '$Site', '$MedRec', '$Notes', >> > $Weight, $BMI, > >> > '$Date'"; > > Also - is it valid to use the word 'Date' as a field name?  Just wondering. It is valid, though It may require quotes (backtick ?)