PHP - Query doesn't seem to work

Question

So I got code which gets row from database, but it doesn't seem to work :/.

$sql = mysql_query("SELECT * FROM steam_users WHERE steamid='$steamid'");

while($row = mysql_fetch_array($sql)){
    print_r($row['tradeurl']);
}

"doesn't seem to work" doesn't tell us much. Which errors do you get? Also you should stop using the mysql_* functions, the entire api is removed from PHP 7. Use PDO or Mysqli instead. — JimL, Apr 09 '16 at 17:15
Then what do you get? And how does that differ from what you were expecting to get? — JimL, Apr 09 '16 at 17:17
http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php?rq=1 — AbraCadaver, Apr 09 '16 at 17:21
Looks like you have the $steamid in quotes which turns it into a string, which is !== integer. — Cloud_Ratha, Apr 09 '16 at 17:23

score 1 · Answer 1 · answered Apr 09 '16 at 17:42

1

Could be quotes problem try

$sql = mysql_query("SELECT * FROM steam_users WHERE steamid='" . $steamid "';");

answered Apr 09 '16 at 17:42

ScaisEdge

1 Answers1