fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt:
> On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner <jim.gi...@albanyhandball.com>
> > ""Jim Giner"" <jim.gi...@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 ?)
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.
Lars Nielsen <l...@lfweb.dk>
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php