[SOLVED] MySql Random Row

[zackcez]

I'm kinda dumb lol here's my code:

<?
$result3 = mysql_query("SELECT * FROM affiliations WHERE link=RAND() LIMIT 1")
or die(mysql_error());
$row3 = mysql_fetch_array($result3);
$linkasd = $row3['link'];
$title =  $row3['title'];
echo '<a href="" . $linkasd . "">" . $title . "</a>';
?>

Btw, this is a vbulletin model (already connected to database)

I've tried a lot of things lol, this was just my last one

[pocobueno1388]

You were close, change your query to

 

SELECT * FROM affiliations ORDER BY RAND() LIMIT 1