|
/* declare some relevant variables */
$hostname = "mysql.whiz.to";
$username = "lodging";
$dbpassword = "lodging";
$userstable = "photos";
$dbName = "lodging";
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $dbpassword) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
$query = "SELECT * FROM $userstable WHERE clientlink='$cl' ORDER BY pagename ASC";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result);
$i = 0;
IF ($number == 0) :
?>
Sorry, There are No Links at this time. ELSEIF ($number > 0) : WHILE ($i < $number): $item = mysql_result($result,$i,"item"); $name = mysql_result($result,$i,"name"); $type = mysql_result($result,$i,"type"); $pagename = mysql_result($result,$i,"pagename"); $i++; ?>
echo $pagename; ?> - Photo}?>
-
echo $name; ?>
|
|