=(select $min_r+FLOOR((MAX(user_id)-$min_r+1)*RAND()) from btb_user) ORDER BY b.user_id LIMIT 1"; $sql="select b.user_id, b.url, a.banner_loc, c.banner_loc as b_loc2 from btb_user b, $tblname_1 a , $tblname_2 c where a.user_id=b.user_id AND b.user_id=c.user_id and b.user_id>=(select $min_r+FLOOR((MAX(user_id)-$min_r+1)*RAND()) from btb_user) ORDER BY b.user_id LIMIT 1"; //echo $sql; $results = mysql_query($sql, $conn); $row_c = mysql_fetch_array($results); mysql_free_result($results); mysql_close($conn); $rand_user=$row_c[0] ?>   Rendom Member  Web Site :