je débute en php. j'ai ecrit ce petit bout de code qui fonctionne très bien:
Code : Tout sélectionner
<?php
if ( $mySobi->id == 0)
{
$database = & JFactory::getDBO();
$user =& JFactory::getUser();
$sql = "SELECT cb_city FROM #__comprofiler WHERE id= {$user->id} LIMIT 1";
$database->setQuery( $sql );
echo $database->loadResult();
}
else
{
$database = & JFactory::getDBO();
$user =& JFactory::getUser();
$sql = "SELECT data_txt FROM #__sobiagenda2_fields_data WHERE itemid= {$mySobi->id} AND fieldid= 1 LIMIT 1";
$database->setQuery( $sql );
echo $database->loadResult();
}
?>
Code : Tout sélectionner
<?php function Load_field() {
if ( $mySobi->id == 0)
{
$database = & JFactory::getDBO();
$user =& JFactory::getUser();
$sql = "SELECT cb_city FROM #__comprofiler WHERE id= {$user->id} LIMIT 1";
$database->setQuery( $sql );
echo $database->loadResult();
}
else
{
$database = & JFactory::getDBO();
$user =& JFactory::getUser();
$sql = "SELECT data_txt FROM #__sobiagenda2_fields_data WHERE itemid= {$mySobi->id} AND fieldid= 1 LIMIT 1";
$database->setQuery( $sql );
echo $database->loadResult();
}}
?>
Pourquoi?
Merci