mysql.php

<?php
$db_host = "localhost";
$db_user = "evolutio";
$db_password = "password";
$db_name = "cms";
$usertable = "usertabelle";
$link = "url";
mysql_connect($db_host,$db_user,$db_password) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error());
?>


userlist.php

<?php
session_start();
include("mysql.php");
echo "<table>";
$sql = "SELECT * FROM $usertable ORDER by name";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)) {
echo "
  <tr>
    <td>".$row["name"]."</td>
    <td>".$row["email"]."</td>
    <td>".$row["rang"]."</td>
  </tr>
";
}
echo "</table>";
?>


url.php

<?php
session_start();
include("mysql.php");
echo "<table>";
$sql = "SELECT * FROM $links ORDER by name";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)) {
echo "
  <tr>
    <td>".$row["url"]."</td>
    <td>".$row["beschreibung"]."</td>
    <td>".$row["hits"]."</td>
  </tr>
";
}
echo "</table>";
?>