<!--#include file="haut.asp"-->
  <%
Dim cnnrecettes
Dim rstresto
Dim sqlresto


cpt = 0
Set rstresto2 = cnnrecettes.Execute("select `tbl_receipe_sante`.`t_rec_num` AS `t_rec_num` from  `tbl_receipe_sante`;")
While Not rstresto2.EOF
			cpt = cpt +1
  rstresto2.MoveNext
Wend

rstresto2.Close
Set rstresto2 = Nothing

Set rstresto = cnnrecettes.Execute("SELECT t_rec_num, t_resto, t_resto_en FROM tbl_resto_sante WHERE parent_cat = 0 ORDER BY t_resto;")
%>
  <p><br>
    <b><%=cpt %> recette(s)</b> </p>
  <p><b>Administration des cat&eacute;gories de recettes.</b></p>
      <p><a href="admin_add_resto.asp?action=start">Ajouter une cat&eacute;gorie</a></p>
<table>
  <tr bgcolor="#CCCCCC"> 
    <td><strong>Français</strong></td>
    <td><strong>Anglais</strong></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <%
While Not rstresto.EOF
								if couleur = "#ffffff" then
									couleur = "#EEEEEE"
								else
									couleur = "#ffffff"
								end if 
%>
  <tr bgcolor="<%= couleur %>"> 
    <td><b><a href=admin_display_receipe.asp?resto=<%= CStr(rstresto("t_rec_num")) %>><%= rstresto("t_resto")%>&nbsp;</a></b></td>
    <td><%= rstresto("t_resto_en")%>&nbsp;&nbsp;</td>
    <td><a href="admin_modify_resto.asp?action=display&resto_id=<%= rstresto("t_rec_num") %>&aff=cat">Modifier</a></td>
    <td><a href="admin_delete_resto.asp?action=verify&resto_id=<%= rstresto("t_rec_num") %>">D&eacute;truire</a></td>
  </tr>
  <%
  rstresto.MoveNext
Wend

rstresto.Close
Set rstresto = Nothing
cnnrecettes.Close
Set cnnrecettes = Nothing
%>
</table>
<!--#include file="bas.asp"-->