1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| <div id="executants">
<h4>EXECUTANTS</h4>
<?php
$sql = "SELECT `users`.`user_name`, `users`.`user_pupitres`
FROM `users`
WHERE `users`.`user_id` <> 0 AND (`users`.`user_membres` = 'Exécutants')
ORDER BY `users`.`user_pupitres`";
$result = DbConnection::select( $sql );
if( DbConnection::hasError() )
{
$error = DbConnection::getError();
}
if( $result )
{
echo TXT_INDENT.TXT_INDENT , '<ul class="id="executants">' , TXT_CRLF;
while( $row = mysql_fetch_object( $result ) )
{
echo TXT_INDENT.TXT_INDENT , '<li>' , $row->user_pupitres , ' </li>' , TXT_CRLF;
echo TXT_INDENT.TXT_INDENT , '<ol>' , $row->user_name , ' </ol>' , TXT_CRLF;
}
echo TXT_INDENT.TXT_INDENT , '</ul>' , TXT_CRLF;
}
?>
</div> |
Partager