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