guest
|
| Posted: 05/30/2002, 12:06 PM |
|
Try using single quotes...
"Tomasz Golebiowski" <tomasz@REMOVENOSPAMmax.pl> wrote in message
news:a4jfkh$6ok$1@news.codecharge.com...
> ok, I used:
>
> $usertemporary = "'" .$flduser. "'";
> $user_from_users_temp = dlookup("users_temp", "user", "user="
..$usertemporary);
>
> and it works, I think..
>
>
> "Tomasz Golebiowski" <tomasz@REMOVENOSPAMmax.pl> wrote in message
>news:a4j66v$3lh$1@news.codecharge.com...
> > As I wrote before, putting quotes before and after get_param("user")
causes
> php
> > parse error
> > Do you mean I have to add quotes to the value after retrieving it from
> database,
> > put result in variable and use it in dlookup?
> >
> >
> > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> >news:a4j0hd$m7u$2@news.codecharge.com...
> > > the workaround is to put quotes around user value
> > >
> > > --
> > > Alex
> > > CodeCharge Developer
> > >
> > >
> > > "Tomasz Golebiowski" <tomasz@REMOVENOSPAMmax.pl> wrote in message
> > >news:a4hi4d$net$1@news.codecharge.com...
> > > > MySQL return error when I try to use the following:
> > > > $user_from_users_temp = dlookup("users_temp", "user", "user=" .
> > > > get_param("user"));
> > > >
> > > > i.e. if I enter fx in 'user' field, error says:
> > > > MySQL Error: 1054 (Unknown column 'fx' in 'where clause')
> > > > so it looks like MySQL thinks 'user' is table column, not value.
> > > >
> > > > What is strange this happens only when entered value is text; if
it's
> > > number,
> > > > everything works OK.
> > > > Is there a workaround?
> > > > I've tried to put " or ' before/after get_param, but it causes php
parse
> > > error..
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
 |
|
