Re: search of data base - again
| From: | Gavin | Date: | Fri, 30 Mar 2012 18:55:55 +0000 |
| Subject: | Re: search of data base - again | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48246@lists.php.net to get a copy of this message | ||
|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:
*
|ACTION|
*
|BIT| <http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html>
*
|DATE| <http://dev.mysql.com/doc/refman/5.5/en/datetime.html>
*
|ENUM| <http://dev.mysql.com/doc/refman/5.5/en/enum.html>
*
|NO|
*
|TEXT| <http://dev.mysql.com/doc/refman/5.5/en/blob.html>
*
|TIME| <http://dev.mysql.com/doc/refman/5.5/en/time.html>
*
|TIMESTAMP| <http://dev.mysql.com/doc/refman/5.5/en/datetime.html>
Best Regards,
Gavin
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.giner@albanyhandball.com> wrote: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""Jim Giner""<jim.giner@albanyhandball.com> wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2...It is valid, though It may require quotes (backtick ?)=============== 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?Also - is it valid to use the word 'Date' as a field name? Just wondering.Date) VALUES(null, '$Site', '$MedRec', '$Notes', $Weight, $BMI,> '$Date'";