sql =select UpdateDate, UpdateStatus, NextEvent, time_format(UpdateTime,'%H:%i') as UpdateTime from EventsUpdatetime = 13:02 2010-09-06 2010-09-06sql = Select RemDate from Events where (RemFlag='Y' or DimFlag='Y') and RemDate = current_date() sql2 = Update EventsUpdate set UpdateStatus='Y', UpdateDate=current_date(),UpdateTime='20:43'<br> Next Event = N

in fake nextevent live
<br>sql1 = Select EventId, StartTimeZone, date_format(RemDate,'%Y/%m/%d') as RemDate, time_format(RemTime,'%H:%i') as RemTime from NextEvent where HomePageFlag = 'Y'<br>RemDate = 2 2008/02/19 22:00<br>sql3 = Select EventId,StartTimeZone,date_format(StartDate,'%m') as MONTH1, DAYOFMONTH(StartDate) as Day1, substring(StartDate,1,4) as YEAR1, StartTime as ST, date_format(RemDate,'%Y/%m/%d') as RemDate, time_format(RemTime,'%H:%i') as RemTime from NextEvent where Status='L' and RemDate >= current_date() and DisplayFlag = 'Y' order by YEAR1, MONTH1, Day1, ST asc LIMIT 1<br><br />
<b>Notice</b>:  Undefined variable: NextEventId in <b>/home/ftp-romanolax/www/romanolax.com/fake_nextevent_live.php</b> on line <b>80</b><br />
<br />
<b>Notice</b>:  Undefined variable: NextDate in <b>/home/ftp-romanolax/www/romanolax.com/fake_nextevent_live.php</b> on line <b>80</b><br />
<br />
<b>Notice</b>:  Undefined variable: NextTime in <b>/home/ftp-romanolax/www/romanolax.com/fake_nextevent_live.php</b> on line <b>80</b><br />
<br>NextDate =   change index = 1<br>sql2 = Select EventId,date_format(StartDate,'%m') as MONTH1, date_format(EndDate,'%m') as MONTH2, DAYOFMONTH(StartDate) as Day1, DAYOFMONTH(EndDate) as Day2, substring(StartDate,1,4) as YEAR1, substring(EndDate,1,4) as YEAR2, date_format(StartDate,'%a %m/%d/%Y') as StartDateDisp, date_format(EndDate,'%a %m/%d/%Y') as EndDateDisp, time_format(StartTime,'%l') as StartHour,time_format(StartTime,'%i') as StartMin, StartTime as ST, StartTimeFlag, time_format(EndTime,'%l') as EndHour, time_format(EndTime,'%i') as EndMin, time_format(EndTime,'%p') as EndTimeAM, EndTime as ET, EndTimeFlag, time_format(StartTime,'%h:%i %p') as StartTime1, time_format(EndTime,'%h:%i %p') as EndTime1, StartTimeZone, date_format(RemDate,'%Y/%m/%d') as RemDate, time_format(RemTime,'%H:%i') as RemTime, TBDFlag,Details1,Details2, City,State,Status,GoliveStatus, NextEventFlag,HideWeekFlag,DisplayFlag,HomePageFlag from NextEvent where Status='L' and RemDate >= current_date() and HomePageFlag = 'N' order by YEAR1, MONTH1, Day1, ST asc<br>res1 = 0<br />
<b>Notice</b>:  Undefined variable: HomePageFlag in <b>/home/ftp-romanolax/www/romanolax.com/fake_nextevent_live.php</b> on line <b>198</b><br />

home page flag = 
<br />
<b>Notice</b>:  Undefined variable: HomePageFlag in <b>/home/ftp-romanolax/www/romanolax.com/fake_nextevent_live.php</b> on line <b>199</b><br />
<br> Next Event = N