$root="root";
$password="password";
$db="kkk"
mysql_connect($db,$root,$password);
$sql="delete from table1";
mysql_query($sql);
$password="password";
$db="kkk"
mysql_connect($db,$root,$password);
$sql="delete from table1";
mysql_query($sql);
调试欢乐多
delete from table1;
$host="localhost";
$root="root";
$password="password";
$db="kkk";
mysql_connect($host,$root,$password);
mysql_select_db($db);
$sql="delete from table1";
mysql_query($sql);
TRUNCATE TABLE table_name
如果我选择某数据库的特定字段输出。那么就是
<?
mysql_connect(localhost,root,password);
$db="kkk";
$query = "select * FROM TABLE1 where id=8";
$result=mysql_query($query);
?>
这样得到了result的数据集,那么我该如何得到id=8其他字段的值呢?
我刚学PHP,急用。不好意思!
再线等!
$host="localhost";
$root="root";
$password="password";
$db="kkk";
mysql_connect($host,$root,$password);
mysql_select_db($db);
$query = "select * FROM TABLE1 where id=8";
$result=mysql_query($query);
if ($info=mysql_fetch_array($result))
{
echo $info['filed1'],$info['field2'],$info['field3'];
}
?>