Bonjour,

la requête suivante ne donne pas le même résultat quand elle est exécutée par PHP 5.0.5 ou dans Toad for MySQL. La requête est générée mais ce qui suit est le SQL généré et lancé par la fonction mysql_query (je sais cette fonction et la version de PHP sont obsolètes mais je n'ai pas le choix).

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
drop table if exists tmpNrssListe;
CREATE TABLE tmpNrssListe  
select nrss, numfichier as fic , numFichier as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tactext_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, numFichier as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from targu_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, numFichier as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tdivact_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, numFichier as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tdivdas_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, numFichier as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsaact_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, numFichier as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsadas_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, numFichier as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsafix_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, numFichier as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsardth_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, numFichier as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsaum_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, numFichier as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trssact_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, numFichier as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trssdad_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, numFichier as trssdas_fu, null as trssfix_fu from trssdas_fu where numFichier is not null 
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, numFichier as trssfix_fu from trssfix_fu where numFichier is not null 
order by nrss, fic;
Exemples de résultat différent (pour le RSS n° 5) :
PHP (résultat erroné) :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
nrss	fic	tactext_fu	targu_fu	tdivact_fu	tdivdas_fu	trsaact_fu	trsadas_fu	trsafix_fu	trsardth_fu	trsaum_fu	trssact_fu	trssdad_fu	trssdas_fu	trssfix_fu
5	1																										1
5	2																										2
Toad (résultat correct) :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
nrss	fic	tactext_fu	targu_fu	tdivact_fu	tdivdas_fu	trsaact_fu	trsadas_fu	trsafix_fu	trsardth_fu	trsaum_fu	trssact_fu	trssdad_fu	trssdas_fu	trssfix_fu
5	1																										1
La table trssfix_fu ne contient qu'une ligne avec le NRSS 5 (et cette dernière à un numFichier égal à 1).
J'ai essayé en faisant un "create table" suivit d'un "insert into ... select" mais le résultat est le même.