表里有两条内容:
1111111111111111111111111
2222222222222222222222222
<?php//设置数据库变量
$db_host = 'localhost';
$db_user = 'root';
$db_passw = '123456';
$db_name = 'freebb';$conn = mysql_connect($db_host,$db_user,$db_passw) or die ('数据库连接失败!');
mysql_query("set names 'utf8'");mysql_select_db($db_name,$conn) or die('数据库选定失败!');
$sql = "SELECT * FROM `member` ORDER BY `id` DESC LIMIT 0, 16";$result = mysql_query($sql) or die('数据库查询失败!'); while($mem = mysql_fetch_object($result)) //循环开始
{
$username = $mem->username;
$bbsname = $mem->bbsname;
$bbstype = $mem->bbstype;
?> <li>
<div class="title"><a href="http://<?php echo $username; ?>.lingd.cn/" target="_blank"><?php echo $bbsname; ?></a></div>
<div class="type">[<?php echo $bbstype; ?>]</div>
</li><?php
}
?>
输出显示内容为:
11111111111111111111111111
22222222222222222222222222
11111111111111111111111111
22222222222222222222222222请问这是怎么回事呢,求解
1111111111111111111111111
2222222222222222222222222
<?php//设置数据库变量
$db_host = 'localhost';
$db_user = 'root';
$db_passw = '123456';
$db_name = 'freebb';$conn = mysql_connect($db_host,$db_user,$db_passw) or die ('数据库连接失败!');
mysql_query("set names 'utf8'");mysql_select_db($db_name,$conn) or die('数据库选定失败!');
$sql = "SELECT * FROM `member` ORDER BY `id` DESC LIMIT 0, 16";$result = mysql_query($sql) or die('数据库查询失败!'); while($mem = mysql_fetch_object($result)) //循环开始
{
$username = $mem->username;
$bbsname = $mem->bbsname;
$bbstype = $mem->bbstype;
?> <li>
<div class="title"><a href="http://<?php echo $username; ?>.lingd.cn/" target="_blank"><?php echo $bbsname; ?></a></div>
<div class="type">[<?php echo $bbstype; ?>]</div>
</li><?php
}
?>
输出显示内容为:
11111111111111111111111111
22222222222222222222222222
11111111111111111111111111
22222222222222222222222222请问这是怎么回事呢,求解
while($mem = mysql_fetch_assoc($result)) //循环开始
{
echo $men['username'];
echo $men['bbsname'];
}这样会重复吗?看看
?>
{
echo $mem['username'];
echo '<br/>';
echo $mem['bbsname'];
}
?>这样啊试下
在循环里 var_dump($men);
我看看是什么内容
键值里有个空格,所以导致没查到结果
<?php//设置数据库变量
$db_host = 'localhost';
$db_user = 'root';
$db_passw = '123456';
$db_name = 'freebb'; $conn = mysql_connect($db_host,$db_user,$db_passw) or die ('数据库连接失败!');
mysql_query("set names 'utf8'");//选定数据库
mysql_select_db($db_name,$conn) or die('数据库选定失败!');
$sql = "SELECT * FROM `member` ORDER BY `id` DESC LIMIT 0, 16";$result = mysql_query($sql) or die('数据库查询失败!');while($mem = mysql_fetch_assoc($result))
{
echo $mem['username'];
echo $mem['bbsname'];
}
?>
刚才$mem写成$men了 现在结果出来还是重复
id username password bbsname
1 support 1234561 support
2 support2 1234561 support2数据库里只有两条数据
while($mem = mysql_fetch_assoc($result))
{
echo $mem['username'];
echo $mem['bbsname'];
}
得出的结果就只会是
supportsupportsupport2support2没有其它的可能,只能是你看错了或者弄错了
搞了半天是一个JS影响到了 去掉JS就正常了
function myGod(id,w,n){
var box=document.getElementById(id),can=true,w=w||100,fq=fq||10,n=n==-1?-1:1;
box.innerHTML+=box.innerHTML;
box.onmouseover=function(){can=false};
box.onmouseout=function(){can=true};
var max=parseInt(box.scrollHeight/2);
new function (){
var stop=box.scrollTop%18==0&&!can;
if(!stop){
var set=n>0?[max,0]:[0,max];
box.scrollTop==set[0]?box.scrollTop=set[1]:box.scrollTop+=n;
};
setTimeout(arguments.callee,box.scrollTop%28?fq:w);
};
};
myGod('gundong',2000);
能帮我看看怎么回事吗
这样假设 box.innerHTML 为 '111';
那么 box.innerHTML+=box.innerHTML; 后,box.innerHTML 为 '111111';