Randomly sort and return 3 values from single user

I have a MySql DataBase with 18 categories for each ID. I want to to be able to fetch all IDs from that database based on the information contained in a single field ( for example where continent = Africa) then randomly choose from among those IDs that are returned from that query, then store the information from several fields in the database for that single ID.
I want to insert the information stored from the various fields for that single ID into several places on a web page using PHP. I want to insert some of the information stored into the HEAD portion of the page in 1 or more of the META TAG fields, & I want to insert some of the information stored from the Database query down the BODY section of the page.
I am new to MySQL and not an expert in PHP by any measure, so please understand if I have posted something in error.

Here is the code I am trying to run but it returns an error message.

<?PHP require_once ('../mysql_connect.php');
$data = ("SELECT embed1, length, email, header FROM redirect WHERE continent = 'Africa'");
ORDER_BY RAND();
LIMIT '1';

// Formulate Query $query = "SELECT embed1, length, email, header FROM redirect WHERE continent = 'Africa' ORDER BY RAND() LIMIT 1"; // Perform Query $result = mysql_query($query); // Check result // This shows the actual query sent to MySQL, and the error. Useful for debugging. if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } // Use result while ($row = mysql_fetch_assoc($result)) { echo $row['embed1']; echo $row['length']; echo $row['email']; echo $row['header']; }

Randomly sort and return 3 values from single user

Randomly Sort

JerryD

Dijkgraaf

whoisgregg

JerryD

whoisgregg

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week