<?
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "saturn";$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql ='INSERT INTO counter(name,new)VALUES(saturn1,1)';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
mysql_close($conn);//.............
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="select count(*) from counter where name = 'saturn1' ";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
$row[0];
//print_r($row);
mysql_free_result($result);
?>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>SATURN的减肥</title>
</head><body><p align="center"><font size="7" color="#008000">SATURN</font><font size="7" color="#FF0000">的减肥</font></p>
<p align="center"> </p>
<p align="center"><font color="#0000FF">开站至今,已经有</font><font size="6" color="#800080"><? echo $row[0] ?></font><font color="#0000FF">人访问</font></p>
<p align="center"> <font color="#0000FF"> 还没有人成功.....</font></p></body></html>
程序执行后数字没有反应,请大家帮忙看看错误在那里!!!
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "saturn";$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql ='INSERT INTO counter(name,new)VALUES(saturn1,1)';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
mysql_close($conn);//.............
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="select count(*) from counter where name = 'saturn1' ";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
$row[0];
//print_r($row);
mysql_free_result($result);
?>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>SATURN的减肥</title>
</head><body><p align="center"><font size="7" color="#008000">SATURN</font><font size="7" color="#FF0000">的减肥</font></p>
<p align="center"> </p>
<p align="center"><font color="#0000FF">开站至今,已经有</font><font size="6" color="#800080"><? echo $row[0] ?></font><font color="#0000FF">人访问</font></p>
<p align="center"> <font color="#0000FF"> 还没有人成功.....</font></p></body></html>
程序执行后数字没有反应,请大家帮忙看看错误在那里!!!
你先把你发的那N个帖结了再说吧,一直在提问……
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="select count(*) from counter where name = 'saturn1' ";
$result=mysql_db_query($mysql_database,$sql,$conn);
$row=mysql_fetch_row($result);
print_r($row);
mysql_free_result($result); 把你print_r出来的数组贴出来。
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "saturn";$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql ="INSERT INTO counter(name,new)VALUES('saturn1',1)";
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
//mysql_close($conn);//.............
//$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$sql="select count(*) from counter where name = 'saturn1' ";
$result=mysql_query($sql);
$row=mysql_fetch_row($result);
//$row[0];mysql_free_result($result);
?>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>SATURN的减肥 </title>
</head><body><p align="center"> <font size="7" color="#008000">SATURN </font> <font size="7" color="#FF0000">的减肥 </font> </p>
<p align="center"> </p>
<p align="center"> <font color="#0000FF">开站至今,已经有 </font> <font size="6" color="#800080"> <? echo $row[0] ?> </font> <font color="#0000FF">人访问 </font> </p>
<p align="center"> <font color="#0000FF"> 还没有人成功..... </font> </p></body></html>