On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> wrote: > > ""Jim Giner"" <jim.giner@xxxxxxxxxxxxxxxxxx> 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 ?) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php