Gautier,
ta base ne doit pas être nickel :
$requete = "SELECT bib_id, bib_nom, base, search_type,
count(*) as nb_attr FROM z_bib left outer join z_attr on bib_id=attr_bib_id
group by bib_id, bib_nom, base, search_type ORDER BY bib_nom, base, search_type
";
$res = mysql_query($requete, $dbh); $nbr = mysql_num_rows($res);
Ca passe impeccable chez moi... !
CREATE TABLE z_attr (
attr_bib_id int(6) unsigned NOT NULL default '0', attr_libelle varchar(250) NOT NULL default '', attr_attr varchar(250) default NULL, PRIMARY KEY (attr_bib_id,attr_libelle) ) TYPE=MyISAM; # -------------------------------------------------------- # # Structure de la table `z_bib` # CREATE TABLE z_bib ( bib_id int(6) unsigned NOT NULL auto_increment, bib_nom varchar(250) default NULL, search_type varchar(20) default NULL, url varchar(250) default NULL, port varchar(6) default NULL, base varchar(250) default NULL, format varchar(250) default NULL, auth_user varchar(250) NOT NULL default '', auth_pass varchar(250) NOT NULL default '', PRIMARY KEY (bib_id) ) TYPE=MyISAM;
|
Title: Message
- [PMB-DEVEL] bug admin/z39.50 Gautier Michelin
- [PMB-DEVEL] RE : Re: bug admin/z39.50 Eric ROBERT
- [PMB-DEVEL] RE : Re: bug admin/z39.50 Gautier Michelin
- [PMB-DEVEL] Re: RE : Re: bug admin/z39.50 Eric ROBERT
- [PMB-DEVEL] Re: RE : Re: bug admin/z3... François Lemarchand