<?php
// On se connecte à la base de données:
require "codbfile";
// On récupère la liste des marques
$sql="select * from marque order by nom_marque";
$result_marque=mysql_query($sql)
				or die ("Impossible de charger la liste des marques");
parametres_generaux();
?>


<form action="admin_cd.php?action=<?php echo "$cible_action"; ?>" method="post">
<table align="center" border="0">
	<tr><input type="hidden" name="id_cd" value="<?php echo @$id_cd ?>"></tr>
	<tr><td>Nom du CD : </td><td><input type="text" name="nom_cd" value="<?php echo @$nom_cd ?>" size="50" maxlength="100"></td></tr>
	<tr><td>Numéro du CD : </td><td><input type="text" name="numero_cd" value="<?php echo @$numero_cd ?>" size="50" maxlength="30"></td></tr>
	<tr><td>Photo : </td><td><input type="text" name="photo_cd" value="<?php echo @$photo_cd ?>" size="50" maxlength="200">&nbsp;&nbsp;<a href='upload_form.php?action=new&path_dir=<?php echo "$path_photo_cd"?>' target='_blank'><img src='../images/plus.png' border='0'></a>&nbsp;&nbsp;<a href='upload_form.php?action=del&path_dir=<?php echo "$path_photo_cd"?>&nom_photo=<?php echo "$photo_cd" ?>' target='_blank'><img src='../images/button_drop.png' border='0'></a></td></tr>

	<tr><td>Nombre de CD :</td><td><input type="text" name="nombre_cd" size="50" maxlength="2" value="<?php echo @$nombre_cd ?>"></td><tr>



	<tr><td>Marque du cd :<br><a href="admin_marque.php?action=new_form" target="_blank"><img src="../images/plus.png" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="admin_marque.php?action=edit_list" target="_blank"><img src="../images/button_edit.png" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="admin_marque.php?action=del_form" target="_blank"><img src="../images/button_drop.png" border="0"></a></td><td><select name="id_marque">
<?php
// On crée la liste des marques disponibles :
$id_marque_base=@$id_marque; //Pour garder en mémoire la valeur après extraction
while ($ligne = mysql_fetch_array($result_marque))
{ extract($ligne);
echo "<option value='$id_marque'";
	if ($id_marque == $id_marque_base)
	{ echo "selected='yes'";
	}
echo ">$nom_marque</option>\n";
}
?>
	</select></td></tr>

	<tr><td>Recompense(s) du cd :<br><a href="admin_recompense.php?action=new_form" target="_blank"><img src="../images/plus.png" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="admin_recompense.php?action=edit_list" target="_blank"><img src="../images/button_edit.png" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="admin_recompense.php?action=del_form" target="_blank"><img src="../images/button_drop.png" border="0"></a></td>
	<td valign='top'><a href='admin_corresp_cd_recompense.php?action=edit_form&id_cd=<?php echo "$id_cd"; ?>' target='_blank'>Modifier</a></td></tr>




	<tr><td align="left">Commentaire : </td></tr>
	<tr><td colspan='2' align='center'><textarea name="commentaire_cd" cols="55" rows="8"><?php echo @$commentaire_cd; ?></textarea></td></tr>
	
	<tr><TD>Date d'avant dernière écoute :</TD><td><input type="text" name="date_avant_derniere_ecoute_cd" value="<?php echo "$date_avant_derniere_ecoute_cd"; ?>" <em>(aaaa-mm-jj)</em></td></tr>
	<tr><TD>Date de dernière écoute :</TD><td><input type="text" name="date_derniere_ecoute_cd" value="<?php echo "$date_derniere_ecoute_cd"; ?>" <em>(aaaa-mm-jj)</em></td></tr>


	<tr><td colspan="2" align="right">
	<?php
	if($cible_action=="new_sql")
	{ echo "Administrer les détails <input type='checkbox' name='go_to_edit' value='oui' checked='yes'>&nbsp;&nbsp;";} ?>
	<input type="submit" value="Enregistrer"></td></tr>
</table>
</form>

<hr>


