Announcement

Collapse
No announcement yet.

using value of querystring in sql where clause

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • using value of querystring in sql where clause

    can I use the value of a URL querystring in the sql where clause to only show records based on a passed querystring parameter?

  • #2
    Yes of course. The most easy way is to use a global variable in the sql: where [myparms]
    In the onscriptinit you can use $_GET to get the variable and set [myparms]=$_GET(something from the url);

    the final result must be a valid sql statement, obviously.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X