1 Replies - 108 Views - Last Post: 24 February 2013 - 02:37 AM Rate Topic:

Reputation: 0

Ho to get a random row from mysql database with limit in php

Posted 23 February 2013 - 10:53 PM

Hi guys i am not know how to get a random row from mysql database in use php Like this

<?php $sql = mysql_query("SELECT * FROM users WHERE id='1'");

but i want to know how to get the row in random chance - 1/10

Is This A Good Question/Topic? 0

Replies To: Ho to get a random row from mysql database with limit in php

Reputation: 1258

Re: Ho to get a random row from mysql database with limit in php

Posted 24 February 2013 - 02:37 AM

<?php $sql = mysql_query("SELECT * FROM users WHERE id='1' LIMIT 4, 1");

would retrieve the 5th row (rows are indexed from 0). So construct

<?php $sql = mysql_query("SELECT * FROM users WHERE id='1' LIMIT $ran, 1");

where $ran is your random number.

Refer to my signature: the mysql library is deprecated and you should be using parameterized statements.

Was This Post Helpful? 0

Page 1 of 1