Mysql query works in phpmyadmin, but not in php

Asked Nov 22 '14 at 11:12

Active Nov 22 '14 at 12:12

Viewed 84 times

My friend has asked me about fix his old php script. I have a strange problem with it.

My query:

select * from users where login='Anna Jastrząb'

$login = trim($login);
$us = mysql_query("select * from users where login='$login'");
$w = mysql_fetch_array($us);
die($w['id']);

And it doesn't work! When I die() my mysql_query and copy it to phpmyadmin, it works.

Thanks

edited Nov 22 '14 at 12:12

Pரதீப்

88,697
17
124
160

asked Nov 22 '14 at 11:12

Kriss

use mysql_fetch_array($us, MYSQL_ASSOC); n try to avoid using mysql insted use mysqli – user3510665 Nov 22 '14 at 11:15
mysql_query('set names "utf8"'); fixed my problem, lol. Thanks. – Kriss Nov 22 '14 at 11:16
Try this: $query = "SELECT * FROM `users` WHERE `login` = '" . "$login . "'"; – Jackerbil Nov 22 '14 at 11:16
[You should not be using `SET NAMES` but the `mysql_set_charset` function instead.](http://stackoverflow.com/q/5288953/53114) – Gumbo Nov 22 '14 at 11:20
1

You should not be using a deprecated API !!! See PHP's PDO/mysqli_ APIs and prepared statements. – Strawberry Nov 22 '14 at 13:15

Mysql query works in phpmyadmin, but not in php

0 Answers0