|DATE| <http://dev.mysql.com/doc/refman/5.5/en/datetime.html> => MySQL
permits some keywords to be used as unquoted identifiers because many
people previously used them. Examples are those in the following list:
On 30/03/2012 19:48, Lars Nielsen wrote:
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> wrote:
""Jim Giner""<jim.gi...@albanyhandball.com> wrote in message
Martijn& Jim -
Is it just the date that is the problem?
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.
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,>
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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php