/* 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"); $queryb = "SELECT * FROM $userstable WHERE item='$p'"; $resultb = MYSQL_QUERY($queryb); $numberb = MYSQL_NUMROWS($resultb); $ib = 0; IF ($numberb == 0) : ELSEIF ($numberb > 0) : WHILE ($ib < $numberb): $item = mysql_result($resultb,$ib,"item"); $clientlink = mysql_result($resultb,$ib,"clientlink"); $pagename = mysql_result($resultb,$ib,"pagename"); $name = mysql_result($resultb,$ib,"name"); $body = mysql_result($resultb,$ib,"body"); $type = mysql_result($resultb,$ib,"type"); $ib++; ENDWHILE; ENDIF; IF ($type==text){?>
}ELSE{?> }?>