Can't print tables under SPIP with PHP

hi everyone,
So i have to do some kind of a visual table to see who is in vacation. But the problem is that I am a beginner in PHP and all kind of web programming. So if anybody knows how SPIP works with PHP and can help me.

here i my code :
[php]<?php
inclure(“squelettes/sql.php”);
inclure(“squelettes/form.php”);
inclure(“squelettes/auth.php”);
if (!$link = connexion_sql())
{
print("\n");
return;
}
else
{
print("<table class=“annuaire”>\n" .

\n” .
“\t[fr]Nom[en]Name\n” .
“\t[fr]Prénom[en]First name\n” .
“\t[fr]De[en]From\n” .
“\t[fr]À[en]To\n” .);
$query = "SELECT id_membre,LOWER(membre.nom) AS nom," .
         "DATE_FORMAT(arrivee,'%e/%c/%Y') AS arrivee, DATE_FORMAT(depart, '%e/%c/%Y') AS depart," .
		 "LOWER(prenom) AS prenom,telephone" .
		 "FROM membre" .
		 "ORDER by membre.nom;";
$resource = requete_sql($query);
  	while($membre = mysql_fetch_assoc($resource))
{	   
	print(">\n" . htmlspecialchars($membre["nom"]) . "</a></td>\n" .
          "\t<td>" . htmlspecialchars($membre["prenom"]) . "</td>\n" .
          "\t<td>" . htmlspecialchars($membre["arrivée"]) . "</td>\n" .
          "\t<td>" . htmlspecialchars($membre["depart"]) . "</td>\n" . "\n");
           

}

}
?>[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service