Re: search of data base - again
| From: | Jim Giner | Date: | Fri, 30 Mar 2012 17:49:05 +0000 |
| Subject: | Re: search of data base - again | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48243@lists.php.net to get a copy of this message | ||
""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.