Re: search of data base - again

[Matijn Woudt <tijnema@xxxxxxxxx>]

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