Code: Select all
<?php
/* Connect to Database */
$sqlcon = mysql_connect("myServer","myUser","myPass") or die("Connection Failed: " . $mysql_error());
/* Choose the database to run queries on */
mysql_select_db("myDB") or die("Could not select database");
/* Run a query and stuff results into a variable */
$result = mysql_query("SELECT SponsorID FROM sponsors WHERE tier_level = 1");
/* Error Check */
if (!$result){
echo 'Could not run query: ' . mysql_error();
exit;
}
/* Select three random SponsorID's */
$randIDArray = array_rand($result, 3);
/* Choose first random SponsorID*/
$result_one = mysql_query("SELECT company_url, image_path, image_alt FROM sponsors WHERE SponsorID = $randIDArray[0]");
/* Choose second random SponsorID*/
$result_two = mysql_query("SELECT company_url, image_path, image_alt FROM sponsors WHERE SponsorID = $randIDArray[1]");
/* Choose third random SponsorID*/
$result_three = mysql_query("SELECT company_url, image_path, image_alt FROM sponsors WHERE SponsorID = $randIDArray[2]");
?>-X
feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]