ban_url\" target=\"_blank\" title=\"$row->ban_text\">ban_image\" alt=\"$row->ban_text\" width=\"468\" height=\"60\" align=\"middle\" border=\"0\">"; $ban_view = $row->ban_views + 1; // update the 'times viewed' counter on the banner mysql_query("update ".banners." set ban_views = $ban_view where ban_id = $row->ban_id"); } // count how many banners we have $query = mysql_query("select * from ".banners2.""); $total = mysql_num_rows($query); // lets create a random number $random = (rand()%$total); // retrieve the record number corresponding to the generated random number $query = mysql_query("SELECT * FROM ".banners2." LIMIT $random, 1"); while ($row=mysql_fetch_object($query)) { echo"ban_url\" target=\"_blank\" title=\"$row->ban_text\">ban_image\" alt=\"$row->ban_text\" width=\"468\" height=\"60\" align=\"middle\" border=\"0\">"; $ban_view = $row->ban_views + 1; // update the 'times viewed' counter on the banner mysql_query("update ".banners2." set ban_views = $ban_view where ban_id = $row->ban_id"); } ?>