0

I have a query which should return a single row, I have tested my query in SQL and it runs correctly and gives me a result, but in php it returns a blank array?

This is my php code below

    $user = $userArray['user'] = $messageInfo['user'];
    $message = $userArray['usersMessage'] = $messageInfo['message'];

    $getUsersRank = "SELECT rank from users WHERE username = '.$user.'";

    $getUsersRankQuery = $db->prepare($getUsersRank);

    $getUsersRankQuery->execute();

    $rank = $getUsersRankQuery->fetchAll();

    print_r($rank);

$userArray is an array like this 

(
    [user] => kieronapple
    [usersMessage] => hi
)
Kieron606
  • 613
  • 3
  • 13
  • 28

1 Answers1

1

you must put your string var value into 2 ' and remove . from your query, you may end the " with ' and it is not true, also the string inside 2 " translated by PHP so you should update your query to be :

$getUsersRank = "SELECT rank from users WHERE username = '$user'";
Gouda Elalfy
  • 6,888
  • 1
  • 26
  • 38