PHP SQL - Random Select 1 Row, Where ID = x

Question

I have a MySQL database and I need a PHP to pull a random row. I have successfully created

$query = "SELECT * FROM $usertable
          WHERE region='UK'          
          ORDER BY RAND() LIMIT 1";

This successfully randomly pulls a row; however, it is not limited to where region=2.

I need to be able to:

pull randomly when region=UK
pull randomly when region=UK or ##

(where ## is actually another region, for example, YK = Yorkshire)

Basically I need it to select rows randomly but ONLY when region=UK.

region is a label for one of my fields/collumns, and UK is the content of the VARCHAR in that for a number of rows.

I have the rest of the code sorted.

I have a simple database and the php as follows:

<?php
//Sample Database Connection Syntax for PHP and MySQL.
//Connect To Database
$hostname="carbonmarketing.db.9606426.hostedresource.com";
$username="MarketReadOnly";
$password="Read0nly1";
$dbname="carbonmarketing";
$usertable="ClientList";
$advertfooter = "advertfooter";
mysql_connect($hostname,$username, $password) or die ("<html>%MINIFYHTML4333ddb1f6ba50276851b9f9854a5c817%</html>");
mysql_select_db($dbname);
# Check If Record Exists
$query = "SELECT * FROM $usertable
          WHERE region='UK'          
          ORDER BY RAND() LIMIT 1";
$result = mysql_query($query);
if($result)
{
    while($row = mysql_fetch_array($result))
    {
        $advertfooter = $row["$advertfooter"];
        echo "$advertfooter";

    }
}
?>

But, it's just pulling randomly for all values of the region column

Let me know if it would help for you to see the database.

I am new to PHP and SQL and moving to fast (running before I can walk haha) — Henry Aspden
– Henry Aspden, Commented Oct 1, 2012 at 11:55

Mihai Iorga · Accepted Answer · 2012-10-01 11:56:20Z

2

Make and array with your regions and implode them:

$region = array('UK', 'YK');
$implode = implode("', '", $region);
$query = "SELECT * FROM `".$usertable."` WHERE `region` IN ('".$implode."') ORDER BY RAND() LIMIT 1";

answered Oct 1, 2012 at 11:56

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Riz · Accepted Answer · 2012-10-01 11:56:07Z

1

$query = "SELECT * FROM $usertable
          WHERE region IN ('UK','YK')          
          ORDER BY RAND() LIMIT 1";

answered Oct 1, 2012 at 11:56

Riz

10.3k8 gold badges43 silver badges54 bronze badges

2 Comments

Henry Aspden Over a year ago

ahh I tried this method but as $query = "SELECT * FROM $usertable WHERE region IN (UK, YK) ORDER BY RAND() LIMIT 1";

Riz Over a year ago

You forgot single quotes around region names.

Collectives™ on Stack Overflow

PHP SQL - Random Select 1 Row, Where ID = x

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related