Beispiel #1
0
</div>
	<div class="wrapper">
		<div class="wF">
			<div class="boxStyle1">
				<p><h1><?php 
echo $userName;
?>
's posts:</h1></p>
				<p><div class="boxStyle1" id="avatarBox"><img src="<?php 
echo $avatarUrl;
?>
"/></div></p>
				<p>
					<table>
						<?php 
$schs = $um->getListingConnection()->prepare("SELECT `textId` FROM `schools` ORDER BY `name` DESC LIMIT 100");
$schs->execute();
$schs->store_result();
$schs->bind_result($school);
if ($userName != null) {
    $count = 0;
    while ($schs->fetch()) {
        $mypost = $um->getListingConnection()->prepare("SELECT `identifier`, `category`, `title`,  `date` FROM `" . $school . "` WHERE `userid` = ? ORDER BY `id` DESC");
        $mypost->bind_param("s", $uid);
        $mypost->execute();
        $mypost->store_result();
        $mypost->bind_result($identifier, $pCat, $pTitle, $pDate);
        if ($mypost->num_rows > 0) {
            $concatenated = "<tr><th colspan='2'>At " . $um->getSchoolName($school) . "</th></tr><tr><th>Title</th><th class=\"right\">Posted</th></tr>";
            while ($mypost->fetch()) {
                $link = $school . ":" . $identifier;