Session username - help!

[region]

Hello

I have used UltraDev, with Phakt(PHP extension), and MySQL to create a PHP website.

I am having problems however in using the username session variable (KT_Username) as a filter for a recordset.

There are no problems with displaying the variable KT_Username on the page once someone has logged in when I use the code:
<?php echo $HTTP_SESSION_VARS["KT_Username"];?>

However whenever I include KT_Username as a filter, all I end up with is a blank recordset.

I have the following code in the "head" section of the page:
<?php
session_start();
?>

My SQL statement looks like this:
SELECT *
FROM table
WHERE username = 'KT_Username'

and I have defined KT_Username as $HTTP_SESSION_VARS["KT_Username"]

Can anyone suggest where I might be going wrong??

Any help will be very much appreciated. Thanks,
David

[Anon]

HERE username = 'KT_Username'

should be:

HERE username = '$KT_Username'

Diego