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;
----- Original Message -----
Sent: Thursday, November 06, 2003 11:35
AM
Subject: [PMB-DEVEL] bug
admin/z39.50
Warning:
mysql_num_rows(): supplied argument is not a valid MySQL result resource
in c:\program files\easyphp\www\phpmybibli\admin\z3950\zbib.inc.php
on line 65
M�me en ajoutant un
serveur �a passe
pas.
