Question

$sql=mysql_query("select * from user where name=$username");错误，跪求原因

<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("oldboys",$link);
mysql_query("set names gb2312");
$username='testname';
$sql=mysql_query("select * from user where name=$username");
if($sql) echo 'ok';
else echo 'error';
?>
只显示error，我有数据库：
id name pwd
1 testname pwdtest
什么情况呢？求大家指教

Answer 1

$sql=mysql_query("select * from user where name=' $username'");
或
$sql=mysql_query("select * from user where name=" + $username);
两孝陪枯者都可以乱桐
$username要么用单引号要么分离出来巧洞

Answer 2

$sql=mysql_query("晌迹碰select * from user where name='宴谈"州银 + $username + "'");
你试试

Answer 3

<镇知锋?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("oldboys",$link);
mysql_query("set names gb2312");
$username='testname';
$sql=mysql_query("御晌select * from user where name='{$username}'");
if($sql) echo '猛纤ok';
else echo 'error';
?>

Answer 4

$sql=mysql_query("select * from user where 'name'=$username");
这样就首枝册搭斗好了，者宏name是mysql专有名词，不能随便用