Require("../includes/settings.inc"); $home_prefix = "../"; $mycursor = $HTTP_COOKIE_VARS["sprrhs_links"]; $pagesize = 12; $searchkey = $HTTP_COOKIE_VARS["sprrhs_search"]; $searchkeys=explode(";",$searchkey); $selected_title=$searchkeys[0]; $selected_keywords=$searchkeys[1]; // mysql_connect(localhost, pbryant, huggy); $link_id = mysql_connect($db_server, $db_user, $db_password); mysql_select_db($db_database,$link_id); $result = mysql_query("select * from sp_links where ((Title like \"%$selected_title%\") and Status = \"L\" and (Keywords like \"%$selected_keywords%\")) order by Title"); $num = mysql_numrows($result); $mycursor = $mycursor + $pagesize; if ($mycursor >= $num) { $mycursor = $mycursor - $pagesize; } setcookie ("sprrhs_links","$mycursor"); ?>
mouseover gives information - click to visit | |||
---|---|---|---|
";
echo "";
echo mysql_result($result,$i,"Title");
echo " "; if ($c<4) { echo " | ";
$c=$c+1;
} else {
echo "