$sitename = $_GET['do']; If (!$sitename) { $sitename = "botha"; } $connection = mysql_connect("mysql.thebothanspy.com","thebothanspy_vb","b0than5py") or die ("Couldn't connect to the server."); $db = mysql_select_db("thebothanspy_vb", $connection) or die ("Couldn't select database."); $sql2 = "SELECT cell_bgcolor, cell_bgcolor_over, title, link, alink, width, height FROM kh_othersites WHERE commlink = 1 AND alpha = '$sitename' LIMIT 1"; $sql_result2 = mysql_query($sql2,$connection) or die ("Couldn't execute query(2)"); while ($row2 = mysql_fetch_array($sql_result2)) { $cell_bgcolor = $row2["cell_bgcolor"]; $cell_bgcolor_over = $row2["cell_bgcolor_over"]; $title = $row2["title"]; $link = $row2["link"]; $alink = $row2["alink"]; $marquee_width = $row2["width"]; $marquee_height = $row2["height"]; } $scroll_speed = "2"; $sql = "SELECT name, url, txt FROM kh_othersites WHERE commlink = 1 ORDER BY dat DESC"; ?>