$sql = "SELECT hy_id,hy_class,hy_name,hy_tel,hy_fax,hy_addr,hy_post,hy_web,hy_email,hy_info,hy_date FROM cx_huangye WHERE hy_id = "$id " ";改成:$sql = "SELECT hy_id,hy_class,hy_name,hy_tel,hy_fax,hy_addr,hy_post,hy_web,hy_email,hy_info,hy_date FROM cx_huangye WHERE hy_id = $id";
如果是,echo $sql
结果 出现 SELECT top 1 hy_id,hy_class,hy_name,hy_tel,hy_fax,hy_addr,hy_post,hy_web,by_email,hy_info,hy_date FROM cx_huangye WHERE hy_id = 4如果不是,请指点详细点,新手很多东西都还不懂呢
不管怎么样都很谢谢你!
<?php
require_once( 'config.php ');
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$id = $HTTP_GET_VARS["id"];
$sql = "SELECT hy_id,hy_class,hy_name,hy_tel,hy_fax,hy_addr,hy_post,hy_web,hy_email,hy_info,hy_date FROM cx_huangye WHERE hy_id = $id";
mysql_select_db("your_db") or die(mysql_error()); //修改your_db 为你的数据库
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo " <h3 >".$row[0]." </h3 > <br >";
echo " <h3 >".$row[1]." </h3 > <br >";
echo " <h3 >".$row[2]." </h3 > <br >";
echo " <h3 >".$row[3]." </h3 > <br >";
echo " <h3 >".$row[4]." </h3 > <br >";
echo " <h3 >".$row[5]." </h3 > <br >";
echo " <h3 >".$row[6]." </h3 > <br >";
echo " <h3 >".$row[7]." </h3 > <br >";
echo " <h3 >".$row[8]." </h3 > <br >";
echo " <h3 >".$row[9]." </h3 > <br >";
echo " <h3 >".$row[10]." </h3 > <br >";
}
mysql_free_result($result);
mysql_close($conn);?>