Markus Dollinger
|
| Posted: 08/20/2001, 5:51 AM |
|
Hallo!
I would like to use a custom SQL-query with parameters like (simple)
SELECT * FROM xyz WHERE ID=$someparameter
May somebody tell me how to do this with CC and PHP?
My Solution provides an sql-errormessage but the generated site works:
SELECT * FROM t20_produkte WHERE PID=".get_param("PID")."
But with this statement, CC offers me no fields because of the error ...
THX
Markus
|
|
|
 |
Markus Dollinger
|
| Posted: 08/20/2001, 6:20 AM |
|
Markus Dollinger <dollinger@web.de> wrote in
news:Xns91039761AC266dollingerwebde@206.170.14.140:
> I would like to use a custom SQL-query with parameters like (simple)
> SELECT * FROM xyz WHERE ID=$someparameter
>
> May somebody tell me how to do this with CC and PHP?
> My Solution provides an sql-errormessage but the generated site works:
>
> SELECT * FROM t20_produkte WHERE PID=".get_param("PID")."
>
> But with this statement, CC offers me no fields because of the error ...
I have found a solution: just add singlequotes around the get_param e.g.
'" . get_param("someparam") . "'
Markus
|
|
|
|
|
