<html>
<head>
<title>C</title>
<meta name="author" content="Philipp">
<meta name="generator" content="Ulli Meybohms HTML EDITOR">
</head>
<body text="#000000" bgcolor="#FFFFFF" link="#FF0000" alink="#FF0000" vlink="#FF0000">
>>C
<?php
$db = @mysql_connect('XXXX', 'XXXX', 'XXXX') or die('Verbingungsversuch fehlgeschlagen');
$db_check = @mysql_select_db('reiseangebot') or die('konnte die Datenbank nicht wählen');
if($db)
echo ('');
$result = mysql_query('SELECT * FROM `Reiseangebot` , `Reiseveranstalter` WHERE reiseangebot.Zielort LIKE \'C%\' AND Reiseveranstalter.idReiseveranstalter LIKE \'1\'')
;
?>
<table>
<tr>
<td>Zielort</td>
<td>Anfahrt</td>
<td>Link</td>
</tr>
<tr>
<td>
<?php
while($row = mysql_fetch_array($result))
{
echo $row['Zielort'], '
';
}
?>
</td>
<td>
<?php
$result = mysql_query('SELECT * FROM `Reiseangebot` , `Reiseveranstalter` WHERE reiseangebot.Zielort LIKE \'C%\' AND Reiseveranstalter.idReiseveranstalter LIKE \'1\'')
;
while($row = mysql_fetch_array($result))
{
echo $row['Anfahrt'], '
';
}
?>
</td>
<td>
<?php
$result = mysql_query('SELECT * FROM `Reiseangebot` , `Reiseveranstalter` , `Link` WHERE reiseangebot.Zielort LIKE \'C%\' AND Reiseveranstalter.idReiseveranstalter LIKE \'1\' AND Reiseangebot.link_idLink LIKE link.idlink')
;
while($row = mysql_fetch_array($result))
echo "
test", '
' ;
?>
</td>
</tr>
</table>
<div align="center">
ZURÜCK</div>
</body>
</html>