First of all i would like to say that this is the most useful component i have ever install on joomla after 5 years of using joomla.

I have two questions.
I create a page with some forms to add some stuff in the database.And the results of the database after the forms.

First i would like to ask how to hide the forms from public so they can see only the results.Is there a check to see if someone is admin to see the forms ?

Second i would like to ask something about the connection to the database. I have to add to the start of my php code the mysql_connect, mysql_select_db.... Is there a way to connect to the database like joomla does ? If i try to connect without these i get "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource..."

Thanks

Thanks for the kind words.

To check the user type, use:

$User =& JFactory::getUser();
if ($User->gid == 24 || $User->gid == 25) {
 // administrator
}

Admins have gid of 24 and Super Admins 25. If you want to use an external database:

// your db specific settings
$options = array ( 
  'driver' => 'mysql', 
  'host' => 'your-database-server.com', 
  'user' => 'user', 
  'password' => 'password', 
  'database' => 'database-name', 
  'prefix' => '' 
);
// get a mysql class instance using Joomla DB Factory
$Db =& JDatabase::getInstance( $options );

If you want to use the Joomla database, there is already a connection to it. Retrieve it via:

$Db =& JFactory::getDBO();

Ok the user check part works GREAT !!!!!

but i still get "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in " if i use $Db =& JFactory::getDBO();

line of error is

$query3= mysql_query("SELECT * FROM wallpapers WHERE enable = '1'") ;
     while($apo = mysql_fetch_array($query3)) {

You need to supply the database link as the second parameter to mysql_query();

$query3= mysql_query("SELECT * FROM wallpapers WHERE enable = '1'", $Db->_resource) ;
     while($apo = mysql_fetch_array($query3)) {

You can however user the JDatabase methods to query the db.

$db = JFactory::getDBO();  
$query = "SELECT * FROM wallpapers WHERE enable = '1'";
$db->setQuery( $query );
$result = $db->loadObjectList();
if($db->getErrorNum()) {
   JError::raiseError( 500, $db->stderr());
   jexit();
}
foreach($result as $row) {
  echo $row->field_name; // etc..
  echo '<br />';
}

After you get the DB instance, you may also want to check if it was an actual JDatabase instance, or an error (JError instance).

Example:

// your db specific settings  
$options = array (   
  'driver' => 'mysql',   
  'host' => 'your-database-server.com',   
  'user' => 'user',   
  'password' => 'password',   
  'database' => 'database-name',   
  'prefix' => ''   
);  
// get a mysql class instance using Joomla DB Factory  
$Db =& JDatabase::getInstance( $options );  

if (JError::isError($Db)) {
  // we had an error connecting to db
  // Joomla should handle it automatically so just exit
  jexit();
}

One million thanks !!! it works just great !!!
Thanks a lot for you help .
GREAT support !!!
Keep the good work!