Ezra
|
| Posted: 07/30/2002, 10:45 AM |
|
This Before insert event:
$fldclient_id = dlookup("login","client_id","login_id=" . get_session("UserID"));
produces this:
Database error: Invalid SQL: SELECT client_id FROM login WHERE login_id=
MySQL Error: 1064 (You have an error in your SQL syntax near '' at line 1)
Session halted.
Does anybody has an ideia whats wrong?
Thanks :)
|
|
|
 |
folkerts
|
| Posted: 07/30/2002, 5:20 PM |
|
hi, i think what your doing is correct syntax. but the get_session("UserID") does not give anything back to you. You should check your session vars if it is set. For instance like this.
print_r($HTTP_SESSION_VARS);
die;
hope it helps.
|
|
|
|
Nicole
|
| Posted: 08/01/2002, 5:43 AM |
|
Ezra,
most probably the session variable is empty. Try to print it before dlookup() function is executed.
|
|
|
|
|
