<?php
$connect = mysql_connect("localhost", "root", "1234");
mysql_select_db("test");
$sql="select * from ad";
$result=mysql_query($sql,$connect);
while($myrow=mysql_fetch_array($result)){
$array[] = $myrow["id"];
}$array = $array[rand(0,count($array))];
$sql = "select * from ad where id='$array'";
$result=mysql_query($sql,$connect);
$myrow=mysql_fetch_array($result);
echo $myrow["id"]."<br>";
echo $myrow["pic"];
?>
$connect = mysql_connect("localhost", "root", "1234");
mysql_select_db("test");
$sql="select * from ad";
$result=mysql_query($sql,$connect);
while($myrow=mysql_fetch_array($result)){
$array[] = $myrow["id"];
}$array = $array[rand(0,count($array))];
$sql = "select * from ad where id='$array'";
$result=mysql_query($sql,$connect);
$myrow=mysql_fetch_array($result);
echo $myrow["id"]."<br>";
echo $myrow["pic"];
?>
解决方案 »
- 【求教】如何由程序实现配置类似http://www.domain.com/name这样的访问
- 求助怎么查询表中一共有多少条数据
- 【Mysql :Got error 12 from storage engine】
- 求人辅导PHP类技术面试
- 在问下 smarty中 如何扩展函数像网上cms类标签
- 请教一个搜索结果的问题
- PHPEclipse能否在客户端调试服务器的PHP程序?
- php5函数详解的帮助文档
- 请问如何使得PHP得到<iframe></iframe>中的值?
- 请教gd-2.0.1的安装???热心人士请进。。
- 关于SESSION调用的问题!来的都有分
- 我想自动将某个目录下(有子目录)的所有文件加上个头文件,做得到吗?
$mysql= mysql_connect("localhost", "root", "1234");
mysql_select_db("test");
$sql="select count(*) from ad";
$result=mysql_query(sql,$mysql);
if($result)
$row=mysql_fetch_array($result);
$reccount=$row['0'];
$lsi=rand(0,$reccount-1);
$sql="select * from ad limit $lsi,1";
$result=mysql_query($sql,$mysql);
if($result)
$row=mysql_fetch_array($result);
echo $row['id'].<br>;
echo $row['pic'];
mysql_close($mysql);
?>
会出现错误提示:
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in