Re: Manually Inserted Row

Have a look at my (and others previous mails) with the Topic : "Decide witch table within a union" There you'll find my orginal post with a working union, easy to figure out how it works. > Hi, > > RE: Manually Inserted Row > > I'm using PHP to retrieve the values for the manual insert... I originally > tried using > an array created from the mysql query and adding one row manaually and then > sorting the multidimensional array. > > As Richard pointed out, sorting using the database would be much more > efficient. > > So here I am. Stuck again... > > (SELECT ID, Title, Label, Location, Start, End, Time, Description, > Organization, > Department, Contact, Phone, Email, Global, Board, Committee, Status, > TBD_Time , > TO_DAYS(End) - TO_DAYS(Start) + 1 AS Days > FROM site_calendar_v2 > UNION > SELECT '99999', 'No events exist for this month...', '', > '', '', > '0000-00-00', '00:00:00', > '', '', '', '', '', '', > '1', 'BOX', 'EOG', '', '', > as z ) > WHERE Board='BOX' AND Committee='EOG' > ORDER BY z > > > This fails. Any ideas how I can fix this manually inserted row? > Thanks, > > > Keith -- --- Børge Kennel Arivene http://www.arivene.net ---