php code to display a article

[defje]

Simple question

is it possible to show a article by doing a sql query with, more or less outside of joomla (in a joomla component that supports html/php pieces)

i have some code myself but it only works for showing an article title:

Code: Select all

<?php
global $database;
$id = mosGetParam($_REQUEST, 'ff_param_joomlaid',''); 
$query = "SELECT title from jos_content WHERE id = '$id'";
$database->setQuery($query);
$title = $database->loadResult();
return $title;
?>

works

but

Code: Select all

<?php
global $database;
$id = mosGetParam($_REQUEST, 'ff_param_joomlaid',''); 
$query = "SELECT fulltext from jos_content WHERE id = '$id'";
$database->setQuery($query);
$fulltext = $database->loadResult();
return $fulltext;
?>

doesn't , some kind of protection i guess, do i miss some code?

[defje]

Even more stupid is that this DOES work when i do it for the introtext!

[de]

fulltext is a reserved word in MySQL and you need to escape it using backticks.