$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";
解决方案 »
- 请教下函数next()的用法。
- php 网页显示图片
- 怎样弹出一个没有工具栏,标题栏,地址栏的最大化窗口,但是保留关闭和最大化按钮
- 谁能帮我看看这个问题啊?
- 每次进行mysql_connect(pconnect)操作后是否都要释放内存?
- 求一个php日期算法的问题
- checkdate() 的用法?参数格式是什么??在线等候.......
- 微信内置浏览器跳转问题
- 想学习PHP。有一定的JavaScript 和 HTML 基础 CSS基本上没碰过
- [Warning] Access denied for user 'root'@'46.101.134.30' (using password: YES)
- 社区网站的发掘盈利新模式
- get传值冲突??
如果是,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);?>