| From: | Chris Smith <csmith(at)squiz(dot)net> |
|---|---|
| To: | "Christian Marschalek" <cm(at)chello(dot)at>, "[PHP] PostgreSQL" <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: Variable question... |
| Date: | 2001-05-10 00:48:57 |
| Message-ID: | 01051010485700.20486@area51.cybersydney.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
Hey,
It might not be translating the array contents properly (because of the
quotes inside the $HTTP_SESSION_VARS? Not sure)...
Try -
$result = pg_exec($c1, "SELECT o_plz FROM ort_tabelle WHERE o_plz =
".$HTTP_SESSION_VARS['user_tabelleXu_o_plz']);
which basically appends the session variable onto the end of the query..
> Can anyone please tell me why this does not work:
>
> $result = pg_exec($c1,"SELECT o_plz FROM ort_tabelle WHERE o_plz =
> $HTTP_SESSION_VARS['user_tabelleXu_o_plz']");
>
> And I have to do the following instead?
>
> $plz = $HTTP_SESSION_VARS['user_tabelleXu_o_plz'];
> $result = query_trans($c1, "SELECT o_plz FROM ort_tabelle WHERE o_plz =
> $plz");
--
Chris Smith
http://www.squiz.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Marschalek | 2001-05-10 00:55:49 | RE: Variable question... |
| Previous Message | Mitch Vincent | 2001-05-10 00:40:08 | Re: Variable question... |