Hi all,
I'm having trouble getting the syntax right in a where clause using variables.
First, after a succesfull login:
$functie = DBLookup("select functie from orkestleden where username='$username'");
Then on the listpage before sql query:
$strWhereClause = ("'$functie' = '$username'");
In this case the where clause should be:
$strWhereClause = ("gitaar = 'jack'"); => SELECT from voorstellingen WHERE gitaar ='jack' (This works! In this case "gitaar" is the $functie I'm trying to find after a succesfull login and "jack" is my username* which I logged in with.)
I know it's probably a terrible newby question; I hope someone can point me in the right direction,
thanks in advance,
Jack.
