Help with Rand()

[RyanSF07]

Hi Everyone,

 

I'm calling a random id from the database. This "id" is the anchor point for other information in other tables.

 

When not called with rand(), the "id" equals $_GET[id], and all other info is called from there (works great).

 

My problem is that by calling with RAND(), the "Get" variable is never set.

 

How can say, "This Rand() variable = the $_GET[id] variable ?"

 

Here is what I'm working with:

(thanks for your help! Ryan

 

 

$sql = "SELECT video.id, title, video_by, video, registered_users.user_name, 
DATE_FORMAT(date, '%M %D, %Y') as date FROM video, registered_users WHERE video.user_id = registered_users.id ORDER BY RAND() limit 1";

$_SESSION[get] = $_GET[id];

$_GET[id]; = THE RANDOM ID CALLED FROM THE DATABASE

$query_result = mysql_query($sql);
$row = mysql_fetch_array($query_result);

$content .= <<<EOD

<iframe src="show_questions.php?id=$_GET[id]" width="500" height="375" 
frameborder="0" scrolling="auto" name="myInlineFrame">
</iframe>
<br / ><br / >
EOD;

 

[btherl]

Can you fetch id from the database query?

 

$id = $row['id']

 

Then in the HTML below you just use $id instead of $_GET[id]

 

I recommend you check your mysql query for errors also.