<?php
/**
* @version 1.0 $
* @package HelloWorld
* @copyright (C) 2005 Andrew Eddie
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
*/

/** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this
location is not allowed.' );

?>

<?php
$database =& JFactory::getDBO();

//$sql = 'SELECT name, username FROM #__users';
$sql="select a.id, a.title, a.introtext, a.created_by,
a.created from jos_content a, jos_content_frontpage b where
a.id=b.content_id and b.ordering='2'";

$database->setQuery( $sql );
$user = NULL;
$user = $database->loadObject();
//echo 'Name: ' . $user->name . '<br />';
echo '<h1>' . $user->title . '</h1><br />';
//echo 'Username: ' . $user->username;
echo ' ' . $user->introtext;
i write this and fetch the result from the database the
result is
The Intranet is up and working !

Our intranet is up and working and should be accessible
from both Mumbai and NOIDA.

As you will notice, this template, look & feel is not in
line with our corporate indentity but we chose the route
of "form-follows-funtion"

In the first phase, we are rolling out functionality that
is critical to all of us - Policies and How-to documents.
In subsequent phases, we will be launching other features.

Keep watching this space for more details

i want to see only 4 line of top then how this may done