j'ai une erreur par ici pd.products_id = p.products_id... je suis nul ou je comprend rien aux jointures...? ptetre les 2?
help plize
Code : Tout sélectionner
SELECT p.products_id, pd.products_name, p.products_price, p.products_image, FROM products p, products_description pd, WHERE pd.products_id = p.products_id and p.products_status = '1' and pd.language_id = '4' GROUP BY p.products_reference DESC LIMIT 10;
Code : Tout sélectionner
CREATE TABLE `products` (
`products_id` int(5) NOT NULL auto_increment,
`products_quantity` int(4) NOT NULL default '0',
`products_model` varchar(18) default NULL,
`products_image` varchar(64) default NULL,
....
PRIMARY KEY (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5677 ;
Code : Tout sélectionner
CREATE TABLE `products_description` (
`products_id` int(5) NOT NULL auto_increment,
`language_id` int(5) NOT NULL default '1',
`products_name` varchar(64) NOT NULL default '',
`products_description` text,
`products_url` varchar(255) default NULL,
`products_viewed` int(5) default '0',
PRIMARY KEY (`products_id`,`language_id`),
KEY `products_name` (`products_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5677 ;
