Tfe

Old stuff/old_sites/ids/data/about.php

<div class="about">
<h3 class="about">About us</h3>

<ul>
<?
    $resultat = $con->assocQuery("SELECT * FROM staff ORDER BY staff_pseudo ASC") or print $con->error;
    foreach($resultat as $key)
    {
	print "\t<li>
	    ";
	    if (!empty($key['staff_mail']))
	    {
	    echo "<a href=\"mailto:".hex_encode($key[staff_mail])."\" title=\"mail\">$key[staff_pseudo]</a>. 
	    ";
	    }
	    else {
	    echo "$key[staff_pseudo]. 
	    ";
	    }
	    echo "	    
	    $key[staff_age]. 
	    $key[staff_role]. 
	    <span class=\"lit\">".(($key[staff_competence] != "?") ? $key[staff_competence] : "")."</span> 
	    <span class=\"color\">$key[staff_pays] : $key[staff_ville]</span>
	    </li>\n";
    }
    
?>
</ul>    

<h3 class="ref">References</h3>
<?
    $contenu = $con->assocQuery("SELECT * FROM realisation WHERE real_importance='Y' ORDER BY real_id DESC LIMIT 1") or print $con->error;
    $contenu = $contenu[0];
echo "
<h4>$contenu[real_nom]</h4>
<div>
    <p><a href=\"$contenu[real_url]\" title=\"url\">$contenu[real_nom]</a> a fais confiance &agrave; InDesignStudio pour la r&eacute;alisation de son site portail.</p>
    <p>$contenu[real_description]</p>
</div>
";
?>
</div>