在php中显示SQL查询结果

您需要从查询获得的结果集中的每一行中获取数据。您可以

mysql_fetch_array()

// Process all rowswhile($row = mysql_fetch_array($result)) {    echo $row['column_name']; // Print a single column data    echo print_r($row);       // Print the entire row data}

将代码更改为此：

require_once('db.php');  $sql="SELECt * FROM  modul1open WHERe idM1O>=(SELECt FLOOR( MAX( idM1O ) * RAND( ) )  FROM  modul1open) ORDER BY idM1O LIMIT 1"$result = mysql_query($sql);while($row = mysql_fetch_array($result)) {    echo $row['fieldname']; }