show_codstat($dbh); break; case 'add': if (empty($form_libelle) && empty($form_pret)) { codstat_form(); } else { show_codstat($dbh); } break; case 'modif': if ($id) { $requete = "SELECT codestat_libelle, statisdoc_codage_import, statisdoc_owner FROM docs_codestat WHERE idcode={$id} "; $res = mysql_query($requete, $dbh); if (mysql_num_rows($res)) { $row = mysql_fetch_object($res); codstat_form($row->codestat_libelle, $row->statisdoc_codage_import, $row->statisdoc_owner, $id); } else { show_codstat($dbh); } } else { show_codstat($dbh); } break; case 'del': if ($id) { $total = mysql_result(mysql_query("select count(1) from exemplaires where expl_codestat ='" . $id . "' ", $dbh), 0, 0); if ($total == 0) { $requete = "DELETE FROM docs_codestat WHERE idcode={$id} "; $res = mysql_query($requete, $dbh); show_codstat($dbh); } else {
show_codstat($dbh); break; case 'add': if (empty($form_libelle)) { codstat_form(); } else { show_codstat($dbh); } break; case 'modif': if ($id) { $requete = "SELECT libelle FROM empr_codestat WHERE idcode={$id} LIMIT 1;"; $res = mysql_query($requete, $dbh); if (mysql_num_rows($res)) { $row = mysql_fetch_row($res); codstat_form($row[0], $id); } else { show_codstat($dbh); } } else { show_codstat($dbh); } break; case 'del': if ($id) { $total = 0; $total = mysql_result(mysql_query("select count(1) from empr where empr_codestat ='" . $id . "' ", $dbh), 0, 0); if ($total == 0) { $requete = "DELETE FROM empr_codestat WHERE idcode={$id} ;"; $res = mysql_query($requete, $dbh); $requete = "OPTIMIZE TABLE empr_codestat ";