Help with my syntax

[classyd]

I cannot figure out where my syntax error is in the following code. Any help would be greatly appreciated.

$query= "SELECT jurcode,login,empnbr FROM paylogin WHERE login=" . $login" and empnbr = " . $empnbr" ;

thanks,
Classyd

[John_Canyon]

query= "SELECT jurcode,login,empnbr FROM paylogin WHERE login=" . $login." and empnbr = " . $empnbr." ;

You were missing the ending concat after login, and empnbr.

Cheers.

[laserlight]

perhaps use:

$query = "SELECT jurcode,login,empnbr FROM paylogin WHERE login='" . $login . "' AND empnbr='" . $empnbr . "'";

[John_Canyon]

yep, laserlight is right, didnt notice the single quotes missing.
as well as your ending concats.

[classyd]

Thanks so much for all the help. I will try that fix.

Classyd

[classyd]

Your reply helped tremendously. Do you know of a way that I can pass the login parameter to other html pages without the info being seen and also is there a way to hide the url's to the other links to prevent someone from going straight to the other pages?