KaiSheng Posted November 12, 2013 Share Posted November 12, 2013 rand(0,100) will not work in my case. I am trying to get a string not integer. Problem : I want to get 1 username of all username in my database. (randomed ones) Anyone know of this? mind helping me? --- code -- $query = "SELECT id,email from users"; $result = mysqli_query($link, $query) or die('error query'); while ($row = mysqli_fetch_array($result)) { $id = $row['id']; $username = $row['username']; echo '$username'; This gives all username, but i only want 1 randomed one. which part of code do i add on? Link to comment https://forums.phpfreaks.com/topic/283832-random-and-get-a-name-from-db/ Share on other sites More sharing options...
KaiSheng Posted November 12, 2013 Author Share Posted November 12, 2013 i got it. i did this. $query = "SELECT id,email from users ORDER BY RAND() LIMIT 1"; Thanks for whoever taking their time to read /Thread solved. Link to comment https://forums.phpfreaks.com/topic/283832-random-and-get-a-name-from-db/#findComment-1457974 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.