[SOLVED] Random Row Display

[jj20051]

I Made The Code Bellow To Display Every A Row In A Database. Now I Would Like To Make It So That It Displays Only One Random Row... Here Is My Code:

 

$sqlstr = mysql_query("SELECT * FROM products");
if (mysql_numrows($sqlstr) != 0) {
while ($row = mysql_fetch_array($sqlstr)) {
?>
<p><?= $row['name'] ?></p>
<p><?= $row['description'] ?></p>
<p><img src="<?= $row['image'] ?>"></p>
<?php
}
}

 

P.S. - Help With Code Would Be Great Since I'm Not that Great At Visualizing PHP Code In My Head Yet.. but Whatever Help You Do Give Thanks In Advance!

[xtopolis]

http://www.phpfreaks.com/forums/index.php/topic,125759.0.html

[Brandon Jaeger]

This should do the trick:

$query = "SELECT * FROM products ORDER BY rand() LIMIT 1"
$result = mysql_query($query);

$row = mysql_fetch_row($result);

echo '<p>'.$row['name'].'</p>';
echo '<p>'.$row['description'].'</p>';
echo '<p><img src="'.$row['image'].'"></p>';

[JasonLewis]

Not mysql_fetch_row(), mysql_fetch_assoc(). mysql_fetch_row() returns a numerical array, so you would need to access them with 0 and 1 and 2 instead of by their name.

[Brandon Jaeger]

Oops! Thanks for pointing that out.

 

$query = "SELECT * FROM products ORDER BY rand() LIMIT 1"
$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

echo '<p>'.$row['name'].'</p>';
echo '<p>'.$row['description'].'</p>';
echo '<p><img src="'.$row['image'].'"></p>';

I'm not sure why I did that, but its fixed now

[jj20051]

Thanks Everyone. Especially Project Fear ( Who Solved The Confusing Part ) and Brandon Jaeger For Providing The Code that Got Me Confused, and Later Fixed It...