Forum PHP.pl

Mam Ci ja taka tabele:

[SQL] pobierz, plaintext 
CREATE TABLE `cathegories` (
  `cathegory_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(8) UNSIGNED DEFAULT NULL,
  `name` varchar(30) NOT NULL DEFAULT '',
  `description` varchar(100) DEFAULT NULL,
  `picture_url` varchar(50) DEFAULT NULL,
  PRIMARY KEY  (`cathegory_id`),
  KEY `parent_id` (`parent_id`)
) TYPE=MyISAM;
[SQL] pobierz, plaintext 

w ktorej trzymane sa kategorie newsow. Jesli pole `parent_id` jest puste to kategoria jest kat. glowna. Moze ono zawierac id innej kategorii, wtedy jest ona podkategoria tejze kategorii (IMG:http://forum.php.pl/style_emoticons/default/winksmiley.jpg)

update2: ops, zapomnialem podac feralnego zapytania (IMG:http://forum.php.pl/style_emoticons/default/tongue.gif)

[SQL] pobierz, plaintext 
SELECT `p1`.`cathegory_id` AS `mainId`, `p1`.`name` AS `mainName`, `p2`.`cathegory_id` AS `subId`, `p2`.`name` AS `subName` 
FROM `phpub_cathegories` AS `p1`, `phpublisher`.`phpub_cathegories` AS `p2` WHERE `p2`.`parent_id` = `p1`.`cathegory_id` AND `p1`.`parent_id` IS NULL
[SQL] pobierz, plaintext 

problem: na localu wszystko smiga, przerzucilem na serwa i dostaje blad:


Moze dalo by sie jakos inaczej zapisac to zapytanie?

update: zmienilem zapytanie na:

[SQL] pobierz, plaintext 
SELECT `p1`.`cathegory_id` AS `mainId` , `p1`.`name` AS `mainName` , `p2`.`cathegory_id` AS `subId` , `p2`.`name` AS `subName` 
FROM `phpub_cathegories` AS `p1` 
LEFT JOIN `phpublisher`.`phpub_cathegories` AS `p2` ON ( `p1`.`parent_id` IS NULL ) 
WHERE `p2`.`parent_id` = `p1`.`cathegory_id`
[SQL] pobierz, plaintext 

i wywala to samo (IMG:http://forum.php.pl/style_emoticons/default/dry.gif)

Ten post edytował borec 9.02.2005, 19:49:07

Wina uprawnień a nie zapytania, ustaw poprawny login i hasło.

glupota ludzka nie zna granic (IMG:http://forum.php.pl/style_emoticons/default/winksmiley.jpg) login i haslo byly dobre tylko nazwa bazy sie nie zgadzala (IMG:http://forum.php.pl/style_emoticons/default/tongue.gif)