MySQL ERROR: (1054) Unknown column 's1.id' in 'on clause'
QUERY:
SELECT
s1.id AS `id`,
s1.lft AS `left`,
s1.rgt AS `right`,
s1.level AS `level`,
IF(s1.lft = s1.rgt-1, '0', '1') AS `has_children`
, d.id,d.title,d.search_title
FROM ad_cat_struct AS s1, ad_cat_struct AS s2 LEFT JOIN ad_cat_data AS d ON s1.id = d.id
WHERE s2.id = 148
AND s1.lft > s2.lft AND s1.rgt < s2.rgt AND s1.level = s2.level+1 ORDER BY s1.lft
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/nstree/NSTree.class.php on line 711
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/nstree/NSTree.class.php on line 711
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/nstree/NSTree.class.php on line 711
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/mysql.class.php on line 213
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/mysql.class.php on line 214
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/nstree/NSTree.class.php on line 711
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haircar/public_html/lib/nstree/NSTree.class.php on line 711 Hair Care Article Directory
Home