[Logician]

Originally Posted by leitel

I am building a directory that will connect to vb user table. I am wondering if I can somehow pass a parameter to the webquery to bring up a particular record by pre-setting a variable in your Query PHPInclude Code (Before) section.

For example:

Query:
SELECT name FROM people WHERE id = $nameid ORDER BY name DESC LIMIT 1

PHPInclude:
$nameid = a value i pull off of the address string


I need to dust off my debugger to see what values exist at this point in the runtime. But can someone give me the syntax to pull a parameter value from the URL?
www.noblood.org/forum/view.php?pg=test2&nameid=9999

Thanks!

I just tried:

Query:
SELECT name FROM people WHERE id = $nameid ORDER BY name DESC LIMIT 1

PHPInclude:
$nameid = 4

$nameid did not resolve. So I take it that the query can not contain php variables?

What you try to do sounds doable. However how you do it depends on vb version (hence webtemplate version) so it can help to know this.

Also it is a good idea if you paste your webtemplate/webquery (with its exact phpinclude code) so that we can check how you did it.