Re: search of data base - again

fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt: > 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 ?) > Hi, Have you tried to write out the generated sql with var_dump() and then feed it to an SQL interface? By using Mysql Query Browser you can easily check it the sql-string is correct. Regards Lars Nielsen <lars@lfweb.dk> LFWeb