Question

php sql语句问题 mysql_query("DELECT FROM say WHERE id =$id");

我在 phpadmin中将id设为了主键和自增
运行
mysql_query("DELECT FROM say WHERE id =$id");
删不了数据
加了
echo mysql_error();
输出了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 'DELECT FROM say WHERE id =6' at line 1
什么问题啊。请高手指教

Answer 1

mysql_query("DELECT FROM say WHERE id =$id");
其中$id是一个变量，需要与sql语句分开来书写。而且delete也写错了。用这一句试试看：
mysql_query("delete FROM say WHERE id =".$id);

Answer 2

就是语法错误，DELECT写错了，应该是mysql_query("DELETE FROM say WHERE id =$id");
这样就ok了，还有$id是可以写在双引号里面的，因为双引号解析变量，而单引号不解析变量

Answer 3

$query = "delete from say where id =".$id;
mysql_query ($query);

Answer 4

delete是写错了..而且那个$id那最好写成 delete from say where id='".$id."'";
中间为单引号,不加这个单引号有时候是会出错的

Answer 5

mysql_query("DELECT FROM say WHERE id =$id");
错误书写：DELECT
应该是：DELETE
标准写法：
$sql="delete from `say` where `id`='$id';
mysql_query($sql);