zackcez Posted June 4, 2008 Share Posted June 4, 2008 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 Link to comment https://forums.phpfreaks.com/topic/108633-solved-mysql-random-row/ Share on other sites More sharing options...
pocobueno1388 Posted June 4, 2008 Share Posted June 4, 2008 You were close, change your query to SELECT * FROM affiliations ORDER BY RAND() LIMIT 1 Link to comment https://forums.phpfreaks.com/topic/108633-solved-mysql-random-row/#findComment-557144 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.