如何显示此结果集 - 它不起作用[关闭]

Question

Im trying to display random postings from my db on my home page, but nothing displays when I insert my code. How would I get the following code to display random rows from my db?

   <?php
require "connect2.php";

  $sql = "SELECT * FROM tablename
          ORDER BY RAND()";
while($row = mysql_fetch_array($sql)){
    $userid = $row["userid"];
    $user = $row["user"];
        $city = $row["city"];
        $desc = $row["description"];
        $title = $row["title"];
    $state = $row["state"];


echo"<h3><font face='helvetica'><font size='4'><b><font color='B80000'>$title</font></font></font></b> &nbsp;<font color='A0A0A0'><a href='profile.php?id=$userid'>$user</a></font>
<font face='helvetica'><font size='3'><br>&nbsp;$desc</font></font><br>

   <h3><font color='101010'> &nbsp;$city,$state&nbsp;<font color='A0A0A0'>$date</font>  </font><a href='bid.php?id=$userid'>Bids</a>";

?>

Answer 1

You're not executing your query. You're just creating a variable that happens to contain an SQL statement. it's like saying $win = 'Win the lottery'; and expecting your bank account to get very large numbers deposited into it.

$sql = 'SELECT ...';
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($result);

$somedata = $row['somefield_from_your_database'];

echo "The value is $somedata";

is the basic sequence of code you need.