include("mysql_compat.php");
$db=mysql_connect('o2000', 'jmevel', 'jmevel01');
mysql_select_db("tournois_tennis_v2", $db);
$s='\'';
?>
Choisissez la rubrique :
include("mysql_compat.php");
$sql = "SELECT * FROM categories ORDER BY name;";
$result=mysql_query($sql,$db);
while ($item = mysql_fetch_array($result))
{
if ($category_selected == NULL) { $category_selected = $item["name"];}
if ($item["name"] != $category_selected) { printf("%s", $item["name"], $item["name"]);
}
else { printf(" %s ", $item["name"], $item["name"]);
}
}
?>
ou ajoutez une nouvelle rubrique
include("mysql_compat.php");
$sql="SELECT id FROM categories WHERE name=$s$category_selected$s";
$result=mysql_query($sql,$db);
$item = mysql_fetch_array($result);
$catnum=$item["id"];
$name=$category_selected;
?>
Choisissez votre article :
include("mysql_compat.php");
$sql="SELECT * FROM articles where id_cat=$catnum";
$result=mysql_query($sql,$db);
while ($item = mysql_fetch_array($result))
{
if ($article_selected == NULL) { $article_selected = $item["sujet"];}
if ($item["sujet"] != $article_selected)
{
printf("%s ", $item["sujet"], $item["sujet"]);
}
else
{
printf(" %s ", $item["sujet"], $item["sujet"]);
$art_sujet=$item["sujet"];
$art_sel=$item["id_art"];
}
}
?>
include("mysql_compat.php");
printf("ou ajoutez un nouvel article ", $catnum, $name);
?>
include("mysql_compat.php");
include("../piedDePage.php");
?>