<?php
/*
This php code is executed while the page is created.
It queries the userlist by sql and creates options for the select list.
*/
$users = ff_select("select name, username from #__users");
$options = '';
if ($users)
foreach ($users as $user)
if ($user->name == document.getElementById('User').value)
$options .= "0;$user->name;$user->username\n";
return $options;
?>

global $userlist;
$this->execPieceByName('ff_InitLib');

$strquery = "SELECT `name`, `username ` FROM #__users ".    
            "ORDER BY name; ";

$rows = ff_select( $strquery );

$userlist="0;Username;0\n";
if (Count($rows))
{
   foreach($rows as $record)
   {
      $userlist.="0;$record->name; $record->username\n";
   }
}

<?php
  global $userlist;
  return $userlist;
?>

// load the standard form creation utilities
$this->execPieceByName('ff_InitLib');

//set globals
global $record;

//set value of id
$rid = ff_getParam('ff_param_rid');

//load existing data
global $record;

//query db
$rows = ff_select("select `title` from `#__categories` where published=1");

$categorie="1;Veuillez choisir un;\n";
   
   if (Count($rows))
{
   foreach($rows as $record)
   {
      $categorie.="0;$record->title; $record->title\n";
   }
}

<?php
  global $categorie;
  return $categorie;
?>

1;Select Color;''
0;Red;red
0;Green;green
0;Blue;blue

<?php
  global $categorie;
  return $categorie;
?>

$categorie.="0;$record->title; $record->title\n";

<?php
  global $categorie;
  return $categorie;
?>

<?php
  global $categorie;
  return $categorie;
?>