Helpful Travel and Business Links
We have assembled these helpful links to assist you in finding some of the best businesses and services.
//===== Default DB Settings=====
$ser = "localhost";
$usr = "appd";
$pas ="";
$db = "appnet";
$dbConn = mysql_connect ($ser,$usr,$pas) or die ('I cannot connect to the database.');
mysql_select_db ($db);
$SQL = "
SELECT links.id,links.name,links.url,links.business,linkcats.name as category FROM links,linkcats WHERE links.catid=linkcats.id
AND linkcats.name != 'appnet'
ORDER BY linkcats.catorder asc, links.business ASC
";
$result = mysql_query($SQL);
$rr = mysql_num_rows($result);
if ($rr > 1){
while ($row = mysql_fetch_assoc($result)) {
$id = $row["id"];
$name = $row["name"];
$url = $row["url"];
$business = $row["business"];
$category = $row["category"];
if ($tsCat <> $category) {
$showCat = " $category: | ";
$tsCat = $category;
}else{
$showCat = "";
}
?>
|
}
?>
|
Here are some additional websites that we have found to be very helpful.
$SQL = "
SELECT id,name,url,business FROM links WHERE
catId = 9
ORDER BY business ASC
";
$result = mysql_query($SQL);
$rr = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) { ?>
">=$row["name"]?>
} ?>
|