echo "<table width='100%' border='0' cellpadding='1'>";

while($row = mysql_fetch_array( $result )) {

$id=($row['id']);
$datumsanzeige=($row['datumsanzeige']);
$datum=(date("d.m.y", strtotime($row["datum"])));
$today = date("d.m.y");

if($datumsanzeige == "fake")
    {
    $datumDef = "$today";
    }
  else
    {
    $datumDef = "$datum";
    }



	
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['position'];
	echo "</td><td>"; 
	echo "$datumDef";
	echo "</td></tr><tr><td>"; 
	echo substr($row['stellenbeschrieb'],0,100);
	echo "...";
	echo "</td></tr>"; 
	echo "<tr><td>";
	echo "<a href=\"stellenDetail.php?id=$row[id]\">  $row[stellenbeschrieb] </a>";
	echo "<tr><td></td></tr>"; 
} 

echo "</table>";
echo mysql_error();

?>

$con = mysql_connect("localhost", "-", "-") or die(mysql_error());
mysql_select_db("-") or die(mysql_error());

mysql_query("SET NAMES 'UTF8'");  



    
$sql = "SELECT * FROM jobs where id = \"$_POST[id]\" ";
echo "$sql";



$result = mysql_query($sql,$con);
	


//print table
echo "<table width='100%' border='0' cellpadding='1'>";

while($row = mysql_fetch_array( $result )) {

$id=($row['id']);
$datumsanzeige=($row['datumsanzeige']);
$datum=(date("d.m.y", strtotime($row["datum"])));
$today = date("d.m.y");

if($datumsanzeige == "fake")
    {
    $datumDef = "$today";
    }
  else
    {
    $datumDef = "$datum";
    }



	
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['position'];
	echo "</td></tr><tr><td>"; 
	echo $row['stellenbeschrieb'];
	echo "</td></tr><tr><td>"; 
	echo "</td></tr>"; 
} 

echo "</table>";
echo mysql_error();

?>