doulang5323 2014-08-28 23:13
浏览 65
已采纳

如何回显PHP / MySQL中的随机行?

I've been going through a number of guides on how to echo data from a random row in a MySQL database and I keep arriving at a blank page.

Here is what I believe to be the best version of code I have so far:

<?php $username="root";$password="notarealpassword";$database="offenders";

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");


$sSQLQuery = "SELECT last_name AND first_name FROM offenders ORDER BY RAND() LIMIT 1";  
$aResult = mysql_query($sSQLQuery); 
WHILE ($aRow = mysql_fetch_array($aResult)):
echo $aRow['last_name'] . " " . $row['first_name'];
ENDWHILE; 

?>

I have tested and made sure the connection to the database is working. Why am I arriving at a blank page and how can I fix it?

Thanks so much!

  • 写回答

2条回答 默认 最新

  • dongxun7301 2014-08-28 23:21
    关注
    1. Don't call mysql_close before making queries;
    2. mysql functions are deprecated, use mysqli instead;
    3. I would use curly brackets instead of WHILE - ENDWHILE;
    4. Column selected must be comma separated (not AND separated):

      $sSQLQuery = "
          SELECT 
            last_name, <- here
            first_name 
          FROM offenders 
          ORDER BY RAND() LIMIT 1";  
      
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 Html备忘录页面制作
  • ¥15 黄永刚的晶体塑性子程序中输入的材料参数里的晶体取向参数是什么形式的?
  • ¥20 数学建模来解决我这个问题
  • ¥15 计算机网络ip分片偏移量计算头部是-20还是-40呀
  • ¥15 stc15f2k60s2单片机关于流水灯,时钟,定时器,矩阵键盘等方面的综合问题
  • ¥15 YOLOv8已有一个初步的检测模型,想利用这个模型对新的图片进行自动标注,生成labellmg可以识别的数据,再手动修改。如何操作?
  • ¥30 NIRfast软件使用指导
  • ¥20 matlab仿真问题,求功率谱密度
  • ¥15 求micropython modbus-RTU 从机的代码或库?
  • ¥15 django5安装失败