|
$sql_query = "SELECT * FROM jos_content, jos_content_frontpage WHERE jos_content.id = jos_content_frontpage.content_id AND content_id = '13'";
$result = mysql_query($sql_query) or die(mysql_error());
$row = mysql_fetch_array($result);
$id = $row[id];
$content = $row[introtext];
print $content;
?>
|
 |
News
$sql_query = "SELECT * FROM jos_content, jos_content_frontpage WHERE jos_content.id = jos_content_frontpage.content_id AND sectionid = '7' ORDER BY jos_content.ordering ASC";
$result = mysql_query($sql_query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {;
$id = $row[id];
$content = $row[introtext];
$title = $row[title];
$content_sub = substr($content,0,100);
//index.php?option=com_content&task=view&id=32&Itemid=47
print '
'.$title.' '.
$content_sub.'... ';
}
// [Mehr...]
?>
Referenzen
$sql_query = "SELECT * FROM jos_content, jos_content_frontpage WHERE jos_content.id = jos_content_frontpage.content_id AND content_id = '34'";
$result = mysql_query($sql_query) or die(mysql_error());
$row = mysql_fetch_array($result);
$id = $row[id];
$content = $row[introtext];
print $content;
?>
|
 |