mysql调用数据能用变量么?

来源：百度知道 编辑：UC知道 时间：2024/06/01 07:44:39
"SELECT * FROM
p8_business_company
WHERE uid=$rs[uid] order by
posttime
DESC LIMIT 1
我这样写的目的是根据每个搜索结果的会员信息的uid调用对应的 数据，但是出错

错误提示
Mysql语句有误,错误报告如下:
数据库连接出错:"SELECT * FROM p8_business_company WHERE uid=$rs[uid] order by posttime DESC LIMIT 1

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SELECT * FROM p8_business_company WHERE uid=$rs[uid] order by posttime ' at line 1
1064

哪位大哥指点一下好么?
我试试。

你应该写成：
SELECT * FROM p8_business_company WHERE uid=".$rs[uid]." order by posttime DESC LIMIT 1

你应该写成：
SELECT * FROM p8_business_company WHERE uid='".$rs[uid]."' order by posttime DESC LIMIT 1 ;

变量要有单引号。

二楼 不必非要单引号。如果是int列可以不加的。一楼的就可以。