set @curday := DAYNAME(CURDATE());
SELECT id, name, `time`, description FROM daily
WHERE
day = @curday
or day = 'all'
or (@curday in ('Sunday','Saturday') and day = 'weekend' )
or (@curday not in ('Sunday','Saturday') and day = 'workday' )
(SELECT C.id, date, 'comment' as tname FROM comment AS C WHERE C.task_id = 1)
UNION
(SELECT D.id, date, 'deal' as tname FROM deal AS D WHERE D.task_id = 1)
ORDER BY date
set @bn:=0;
set @gn:=0;
select boys, girls from
(select @bn := @bn + 1 as num, boys from (SELECT distinct boys FROM `names`) b1) b2
left join
(select @gn := @gn + 1 as num, girls from (SELECT distinct girls FROM `names`) g1) g2
using (num)
foreach ($cn as &$val) {
$sabjects_save = "$val text, "; //
}