国足作广告
话说某国足球队兵败后,“伟哥”找了该国家队一名队员做了一个广...
- 娱乐乐园,
作者 goodlook 发布于 2003-09-02 分类:数据库技术
数据库中有一个表:
news_id news_title news_time news_body
1 news1 2003-06-06 news1body
2 news2 2003-06-08 news2body
我要在news.php中列出所有新闻的news_title和news_itme不出现news_body,并以news_id为传递变量,使下一页 news_show.php中有news_id这条新闻的所有信息
我写了简单的news.php如下:
新闻:
<?php
$dbhost = "localhost";
$dbuser = "h";
$dbpasswd = "1";
$dbname = "h";
mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "SELECT * FROM `tb_news`";
$result = mysql_db_query($dbname, $sql);
if($row = mysql_fetch_array($result)){
do{
echo $row["news_id"]."、".$row["news_title"]."(".$row["news_time"].")
";
}
while($row = mysql_fetch_array($result));
}
?>
可news_show.php我不会写,写了N久都不行,谁教教我?
先谢谢了。。。
逛论坛交流:一个很菜的问题:
<?php
//new_show.php
$news_id=$_GET["news_id"];
$dbhost = "localhost";
$dbuser = "h";
$dbpasswd = "1";
$dbname = "h";
mysql_pconnect($dbhost,$dbuser,$dbpasswd);
$sql = "SELECT * FROM `tb_news` where news_id=$news_id";
if ($result = mysql_db_query($dbname, $sql)) {
$row = mysql_fetch_array($result);
print("news_id:".$row[news_id]."
");
print("news_title:".$row[news_title]."
");
print("news_time:".$row[news_time]."
");
print("news_body:".$row[news_body]."
");
}
?>
>暈倒,會寫第一步顯示,不會寫第二步顯示,只是一個 sql 語句不同而已
2 条回复
回复