JerryD - 2:41 am on Aug 15, 2013 (gmt 0)
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'");