i built an UDT with which i get the News Title and Content Text of an News Artikel by an ID.
Code: Select all
mysql_connect("host","username","password");
mysql_select_db("db");
if ($_GET['booking_id'] == $_GET['booking_id']) {
$abfrage = "SELECT * FROM cms_module_news a, cms_module_news_fieldvals b WHERE a.news_id=".$_GET['booking_id']." AND b.news_id=".$_GET['booking_id']." AND a.news_id=b.news_id";
$ergebnis = mysql_query($abfrage);
if (mysql_num_rows($ergebnis)) {
while($row = mysql_fetch_object($ergebnis)) {
echo "<strong>$row->news_title</strong>";
echo "<p>$row->news_data</p>";
echo "Bild: $row->value";
}
}
else {
$abfrage2 = "SELECT * FROM cms_module_news WHERE NOT EXISTS (SELECT * FROM cms_module_news_fieldvals WHERE cms_module_news_fieldvals.news_id=cms_module_news.news_id) AND news_id=".$_GET['booking_id']."";
$ergebnis2 = mysql_query($abfrage2);
while($row = mysql_fetch_object($ergebnis2)) {
echo "<strong>$row->news_title</strong>";
echo "<p>$row->news_data</p>";
}
}
}
what did i do wrong?