Citation :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>.:Carolo-Namur:::</title>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<BODY background="../_images/fond.gif" text="#000000" link="#000000" vlink="#000000" alink="#000000" OnLoad="window.defaultStatus='Carolo-Namur - www.carolo-namur.be.tf';">
<div align="center"> <table width="740" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="background">
<!--DWLayoutTable-->
<tr> <td width="118" height="70" valign="top" bgcolor="#CCCCCC"><div align="center"><img src="../_images/blaso_gauche.gif" width="70" height="70"></div></td>
<td colspan="3" valign="top" bgcolor="#CCCCCC"> <div align="center"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="480" height="70">
<param name="movie" value="../_flash/titre.swf">
<param name="quality" value="high">
<embed src="../_flash/titre.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="480" height="70"></embed></object>
</div></td>
<td width="112" valign="top" bgcolor="#CCCCCC"><div align="center"><img src="../_images/blaso_droit.gif" width="70" height="70"></div></td>
</tr>
<tr bgcolor="#FFFFFF"> <td height="17" colspan="5" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr bgcolor="#CCCCCC" class="menu"> <td height="18" colspan="5" valign="top"> <div class="menu"><a href="../index.php" target="_parent">Accueil </a>| Comité | Bleu | Agenda | Photos | Historique | Carnet d'adresse | <script language=javascript>
function mywindow(page,name,option){
window.open(page,name,option)
}
</script>
<a href="javascript:mywindow('../_forum/index.php','forum','width=700,height=550, status=yes, directories=no, toolbar=no, location=no, menubar=no, scrollbars=yes, resizable=yes')"><font size="2">Forum</font> </a> | <a href="../_pages/livreor.htm" target="_parent">Livre d?or</a> | <a href="../_pages/liens.htm" target="_parent">Liens</a></div></td>
</tr>
<tr> <td height="35"> </td>
<td width="201"></td>
<td width="102"></td>
<td width="207"></td>
<td></td>
</tr>
<tr> <td height="15" colspan="2" valign="top"><img src="../_images/agenda.png" width="319" height="15"></td>
<td></td>
<td colspan="2" valign="top"><img src="../_images/forum_msg.png" width="319" height="15"></td>
</tr>
<tr> <!-- TemplateBeginEditable name="Agenda" --> <td height="178" colspan="2" valign="top" bgcolor="#CCCCCC" class="news"> <div align="left"> Code :
- <? // on se connecte à MySQL
- $db = mysql_connect('localhost', 'xxxxxxx', 'xxxxxxx');
- // on séléctionne la base
- mysql_select_db('unitelov',$db);
-
- // on créer la requete SQL et on l'envoie
- $sql = 'SELECT id, description FROM pme_agenda ';
-
- // on envoie la requete
- $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
- // on fait une boucle qui va faire un tour pour chaque enregistrements
- while($data = mysql_fetch_array($req))
- {
- // on affiche les informations de l'enregistrements en cours
- echo ' <i>date de naissance : '.$data['description'].'</i><br>';
- }
- // on ferme la connexion à mysql
- mysql_close();
- ?>
|
</div></td>
<!-- TemplateEndEditable --> <td> </td>
<td colspan="2" valign="top" bgcolor="#CCCCCC" class="forum">
Code :
- <? // on se connecte à MySQL
- $db = mysql_connect('localhost', 'xxxxxxx', 'xxxxxx');
- // on séléctionne la base
- mysql_select_db('unitelov',$db);
-
- // on créer la requete SQL et on l'envoie
- $sql = 'SELECT topic_id, topic_title FROM caroloforum_topics ORDER BY topic_id DESC LIMIT 0,11';
-
- // on envoie la requete
- $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
-
- // on fait une boucle qui va faire un tour pour chaque enregistrements
- while($data = mysql_fetch_array($req))
- {
- // on affiche les informations de l'enregistrements en cours
- $length = 40;
- echo "<a href=\"http://uniteloverval.behostings.be/carolo/_forum/viewtopic.php?t=".$data['topic_id']."\"><li>" .substr($data['topic_title'], 0, $length)."</li></a>";
- }
- // on ferme la connexion à mysql
- mysql_close();
- ?>
|
</td>
</tr>
<tr> <td height="15" colspan="2" valign="top"><div align="center"><img src="../_images/bas_petit.png" width="319" height="15"></div></td>
<td></td>
<td colspan="2" valign="top"><div align="center"><img src="../_images/bas_petit.png" width="319" height="15"></div></td>
</tr>
<tr> <td height="46"> </td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr> <td height="15" colspan="5" valign="top"><div align="center"><img src="../_images/edito_bar.png" width="739" height="15"></div></td>
</tr>
<tr bgcolor="#CCCCCC" class="edito"> <!-- TemplateBeginEditable name="Edito" --> <td height="172" colspan="5" valign="top"> <div align="center"></div></td>
<!-- TemplateEndEditable --></tr>
<tr> <td height="15" colspan="5" valign="top"><div align="center"><img src="../_images/edito_bar_bas.PNG" width="739" height="15"></div></td>
</tr>
<tr bgcolor="#FFFFFF"> <td height="25" colspan="5" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr bgcolor="#CCCCCC"> <td height="15" colspan="5" valign="top" class="sign">Copyright Carolo-Namur.be.tf ® Tous droits réservés 2003-2004. Webmaster <a href="ditemonsieur@hotmail.com">Gunth</a> , <a href="kodi40@hotmail.com">Kodi</a> </td>
</tr>
</table>
</div>
</body>
</html>
|