Robots


Website Destinations of Interest

[insert_php]

echo “

“;
echo “

“;
// Set The Databases

$hostname1 = “localhost”;
$username1 = “fot_jumpuser”;
$password1 = “d43edjuhme”;
$database1 = “fot_jumps”;

//Define the query
$myquery = “SELECT title, lastvisit, link, logindetails, imp \n
FROM jumps \n
WHERE heading = ‘Robots’ \n
order by title”;

//connect to the database
$dbh1 = mysql_connect($hostname1, $username1, $password1);
mysql_select_db($database1, $dbh1);

//Run the query and print the result
$queryA = mysql_query($myquery) or die(mysql_error());
while ($rowDB1 = mysql_fetch_array($queryA)) {

$title = $rowDB1[‘title’];
$lastvisit = $rowDB1[‘lastvisit’];
$link = $rowDB1[‘link’];
$imp = $rowDB1[‘imp’];

//Define color of entry
switch ($imp){
case “1”: $fontselection = “orange”; break;
default: $fontselection = “black”;
}
echo “

“;
echo “

“;
echo “

“;
echo “

“;

} //End query

[/insert_php]

Site Last Visit
$title $lastvisit