Re: search of data base - again

["Jim Giner" <jim.giner@xxxxxxxxxxxxxxxxxx>]

""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.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php