Question

php mysql_result

$sqldo="select count(*) as title from $mytable where sub_id<1";
$result=mysql_query($sqldo);
$message_count=mysql_result($result,0,"title");--这一行为什么显示错误～ 哪里写错了？？
我想在MY SQL里删除字段为空的数据~ 得怎么写啊~ 假设有个NAME 要是这个为空的话就删除这一条
DELETE FROM PEPO WHERE NAME IS NULL；
这么写好像不对~ 哪里错啦？

Answer 1

$sqldo="select count(*) from $mytable where sub_id<1";
$result=mysql_query($sqldo);
echo $result;
---------------------------
DELETE FROM `表名` WHERE `字段名` IS NULL 是可以的!!!
我这里可以!