Forum PHP.pl

[SQL] pobierz, plaintext 
INSERT 
INTO mod_xgallery_categories(parent_id,
 name, description) VALUES('$parentID',(SELECT level 
FROM mod_xgallery_categories
 WHERE cat_id = $parentID) + 1,'$name','$description')"
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
INSERT 
INTO mod_xgallery_categories(parent_id,
 name, description) VALUES('$parentID',(SELECT level 
FROM mod_xgallery_categories
 WHERE cat_id = $parentID) + 1,'$name','$description')"
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
INSERT 
INTO mod_xgallery_categories(parent_id,
 name, description) VALUES('$parentID',(SELECT level + 1  
FROM mod_xgallery_categories
 WHERE cat_id = $parentID) ,'$name','$description')"
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
INSERT
INTO mod_xgallery_categories(parent_id,
 level,
name, description) VALUES('39',(SELECT level + 1
FROM mod_xgallery_categories
 WHERE cat_id = 0 LIMIT 1) ,'aaa','aaa')
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
INSERT 
INTO mod_xgallery_categories(parent_id,
 level, name, description)
SELECT 39, level + 1, 'aaa', 'aaa' 
FROM mod_xgallery_categories
 WHERE cat_id = 0 LIMIT 1
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
INSERT 
INTO mod_xgallery_categories(parent_id,
 level, name, description)
SELECT 39, level + 1, 'aaa', 'aaa' 
FROM mod_xgallery_categories
 WHERE id = 
(SELECT id 
FROM mod_xgallery_categories
 WHERE cat_id =0 LIMIT 1)
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT @val=level + 1
FROM mod_xgallery_categories
 WHERE cat_id = 0 LIMIT 1;
INSERT 
INTO mod_xgallery_categories(parent_id,
 level, name, description)
VALUES (39, @val, 'aaa', 'aaa');
[SQL] pobierz, plaintext