phpBB.de

Code: Alles auswählen

$sql = "SELECT * FROM guestbook";
$result = mysql_query($sql) OR die(mysql_error());
while($row = mysql_fetch_assoc($result)) 
{ 
  $id = $row['id'];
  $name = $row['name'];
  $email = $row['email'];
  $homepage = $row['homepage'];
  $location = $row['location'];
  $beruf = $row['beruf'];
  $icq = $row['icq'];
  $date = $row['date'];
  $message = nl2br($row['message']);

  ?>

  <div align="right">
	  <table border="0" width="100%" align="right" cellpadding="2">
		  <tr>
			  <td width="99">Eintrag:</td>
			  <td><?=$id?></td>
		  </tr>
		  <tr>
			  <td width="99">Name: </td>
			  <td><? if($email){
  echo "<a href=\"mailto:" . $email . "\"> " . $name . "</a>\n<br>";
  }
  else{

  echo $name . "\n<br>";
  }?></td>
	  	</tr>
		  <tr>
			  <td width="99">Homepage:</td>
			  <td><? if($homepage){
  echo "<a href=\" " . $homepage . "\"> " . $homepage . "</a>\n<br>";
  }

  else{
  } ?></td>
	  	</tr>
		  <tr>
			  <td width="99">Wohnort: </td>
			  <td><?=$location . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99">Beruf:</td>
			  <td><?=$beruf . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99">ICQ:</td>
			  <td><?=$icq . "\n<br>"; ?></td>
		  </tr>
		  <tr>
			  <td width="99">Message: </td>
			  <td><?=$message . "\n<br>"; ?></td>