// return;
$db = "d60158035";
$host = "drcsr.netfirmsmysql.com";
$user = "u70162562";
$pwd = "8a9de0";
$link = mysql_connect($host,$user,$pwd) or die ("Could not connect to MySQL");
mysql_select_db($db) or die ("Could not select $db database");
$query = "SELECT id, lastupdt, active, name, url FROM campgrounds WHERE active=1 ORDER BY name";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo '';
$lnum = 1;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$str = '' . $line["name"] . '';
printf ('| %s | ', $str);
if ( ! ($lnum++ % 3) )
echo (" \n");
}
echo " \n";
mysql_free_result($result);
mysql_close($link);
?>
|