Discussion :

[nox77]

Bonjour a tous ,
Jais une erreur de syntaxe sur la requette suivante.
Si vous pouviez éclaircire ma lanterne
Je continue mes recherche sur le sujet et vous prévien si je trouve la solution.

requete

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
$requete2 = mysql_query('SELECT cat_id, cat_nom,forum.forum_id, forum_name, forum_desc, forum_post, forum_topic, auth_view, topic_forum.topic_id,  topic_forum.topic_post, post_id, post_time, post_createur, pseudo, id FROM categorie_forum
LEFT JOIN forum ON categorie_forum.cat_id = forum.forum_cat_id
LEFT JOIN post_forum ON post_forum.post_id = forum.forum_last_post_id
LEFT JOIN topic_forum ON topic_forum.topic_id = post_forum.topic_id
LEFT JOIN membres ON membres.membre_id = post_forum.post_createur
WHERE auth_view < '.$level.'ORDER BY cat_ordre, forum_ordre DESC') or die (mysql_error());

Table

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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
/*Basse de donnée du forum*/
 
/*Table `categorie_forum`*/
 
CREATE TABLE `categorie_forum` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_nom` varchar(30) collate latin1_general_ci NOT NULL,
  `cat_ordre` int(11) NOT NULL,
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `cat_ordre` (`cat_ordre`)
);
 
/*Table `forum`*/
 
CREATE TABLE `forum` (
  `forum_id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_cat_id` mediumint(8) NOT NULL,
  `forum_name` varchar(30) collate latin1_general_ci NOT NULL,
  `forum_desc` text collate latin1_general_ci NOT NULL,
  `forum_ordre` mediumint(8) NOT NULL,
  `forum_last_post_id` int(11) NOT NULL,
  `forum_topic` mediumint(8) NOT NULL,
  `forum_post` mediumint(8) NOT NULL,
  `auth_view` tinyint(4) NOT NULL,
  `auth_post` tinyint(4) NOT NULL,
  `auth_topic` tinyint(4) NOT NULL,
  `auth_annonce` tinyint(4) NOT NULL,
  `auth_modo` tinyint(4) NOT NULL,
  PRIMARY KEY  (`forum_id`)
); 
 
/*Table `membres_forum` ATTENTION !!!! a modifier selon la table éxistante*/
 
CREATE TABLE `membres_forum` (
  `membre_id` int(11) NOT NULL AUTO_INCREMENT,
  `membre_pseudo` varchar(30) collate latin1_general_ci NOT NULL,
  `membre_mdp` varchar(32) collate latin1_general_ci NOT NULL,
  `membre_email` varchar(250) collate latin1_general_ci NOT NULL,
  `membre_msn` varchar(250) collate latin1_general_ci NOT NULL,
  `membre_siteweb` varchar(100) collate latin1_general_ci NOT NULL,
  `membre_avatar` varchar(100) collate latin1_general_ci NOT NULL,
  `membre_signature` varchar(200) collate latin1_general_ci NOT NULL,
  `membre_localisation` varchar(100) collate latin1_general_ci NOT NULL,
  `membre_inscrit` int(11) NOT NULL,
  `membre_derniere_visite` int(11) NOT NULL,
  `membre_rang` tinyint (4) DEFAULT 2,
  `membre_post` int(11) NOT NULL,
  PRIMARY KEY  (`membre_id`)
); 
 
/*Table `post_forum`*/
 
CREATE TABLE `post_forum` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_createur` int(11) NOT NULL,
  `post_texte` text collate latin1_general_ci NOT NULL,
  `post_time` int(11) NOT NULL,
  `topic_id` int(11) NOT NULL,
  `post_forum_id` int(11) NOT NULL,
  PRIMARY KEY  (`post_id`)
);
 
/*Table  `topic_forum`*/
 
CREATE TABLE `topic_forum` (
  `topic_id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL,
  `topic_titre` char(60) collate latin1_general_ci NOT NULL,
  `topic_createur` int(11) NOT NULL,
  `topic_vu` mediumint(8) NOT NULL,
  `topic_time` int(11) NOT NULL,
  `topic_genre` varchar(30) collate latin1_general_ci NOT NULL,
  `topic_last_post` int(11) NOT NULL,
  `topic_first_post` int(11) NOT NULL,
  `topic_post` mediumint(8) NOT NULL,
  PRIMARY KEY  (`topic_id`),
  UNIQUE KEY `topic_last_post` (`topic_last_post`)
);
 
/*Table  `parametres`*/
 
CREATE TABLE `parametres` (
  `code` varchar(30) collate latin1_german2_ci NOT NULL default '',
  `valeur` longtext collate latin1_german2_ci,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

[sabotage]

Et l'erreur est ... ?

[nox77]

Oui désolé

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY cat_ordre, forum_ordre DESC' at line 6

[sabotage]

Il doit manquer un espace avant ton ORDER

[nox77]

Oui c'était sa je vien de la trouver aussi merci a toi