Re: search of data base - again

fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt:
> On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner <[email protected]> wrote:
> >
> > ""Jim Giner"" <[email protected]> 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 ?)
> 
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 <[email protected]>
LFWeb


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