SQL doesn't UPDATE the AJAX call when WHERE is specified

Can somebody please help me? I'm writing code to tell when someone enters or leaves a webpage chatroom. The SQL query doesn't work when I add the WHERE portion. When I remove the WHERE username='$userLoggedIn' part, it does update, but it'll list all the users in the database. When I echo the variable $userLoggedIn right before the SQL query, it gives me the correct value each time, so I don't know why this value isn't passing to the SQL query. Another curious thing is that when I take the AJAX PHP code (from userfetch.php) and put it back to the start of the main page (where the call itself was made publicchat.php), the code updates and works well. However, the page ends up looking really messed up though, but I can see that the code executed and UPDATEd on that page. It won't update where it's supposed to, though.
I should also mention that the code does work as it should if I assign a value to $userLoggedIn. This leads me to believe that the problem lies in the variable $userLoggedIn. I did try changing the name itself, but had the same problem. Any thoughts?

Any help is so greatly appreciated!!!

Here is the code:



$userLoggedIn = $_POST['userLoggedIn'];

//enter users into database
$userinchat = $_POST['userinchat'];
if ($userinchat === "yesway"){
    $date_time_now = date("Y-m-d H:i:s");

    echo $userLoggedIn;

    mysqli_query($conn, "UPDATE users SET in_chatroom='yes',      lasttime_spotted='$date_time_now' WHERE username='$userLoggedIn' ");      


function users(){
var xhr1 = new XMLHttpRequest();
xhr1.open('POST' , 'userfetch.php' , true);
xhr1.setRequestHeader('content-type','application/x-www-form-    urlencoded');
xhr1.send('userinchat=' + userinchat + '&userLoggedIn=' + username);
xhr1.onreadystatechange = function()
    document.getElementById('loginperson').innerHTML = xhr1.responseText;
Aimee KatherineAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
Space may be the issue.

Use rtrim(ltrim(userloggedin))

Also first select first with where clause and then chk.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aimee KatherineAuthor Commented:
Thank you so much!  I am so grateful to you!  It solved the problem!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.