1054: Unknown column 'visibilty_type' in 'field list'
select IF( ( (visibilty_type = 'D' OR visibilty_type = 'R') AND no_of_downloads > 0 ), 'no_of_view_or_downloads_cnt', 'skip' ) AS bool_allow from CMSI_cms_page where CONCAT(file_name, '.html') ='index.html' AND /* CASE D */ CASE visibilty_type WHEN 'D' THEN IF( (RTRIM( LTRIM( visibilty_date ) ) <> '' AND visibilty_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= visibilty_date , 1 ) AND IF( (RTRIM( LTRIM( expiry_date ) ) <> '' AND expiry_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) <= expiry_date, 1 ) AND IF( no_of_downloads >0, no_of_view_or_downloads_cnt < no_of_downloads, 1 ) /* CASE R */ WHEN 'R' THEN IF(visibilty_days > 0 OR visible_upto_days > 0, '' <> '' AND IF(visibilty_days > 0, DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= DATE_ADD('0000-00-00', INTERVAL visibilty_days DAY), 1) AND IF(visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('0000-00-00', INTERVAL (visibilty_days + visible_upto_days) DAY),1) AND IF(no_of_downloads > 0, no_of_view_or_downloads_cnt < no_of_downloads,1) , IF(no_of_downloads > 0, no_of_view_or_downloads_cnt < no_of_downloads,1) ) /* CASE '' */ WHEN '' THEN 1 END
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/andrew65/public_html/share-your-recipes/classes/class.procedure.php on line 92

Warning: Cannot modify header information - headers already sent by (output started at /home/andrew65/public_html/share-your-recipes/classes/class.procedure.php:62) in /home/andrew65/public_html/share-your-recipes/cms/index.php on line 29