Manually Inserted Row

From: Date: Tue, 31 Oct 2006 19:20:37 +0000
Subject: Manually Inserted Row
Groups: php.general 
Request: Send a blank email to php-general+get-243971@lists.php.net to get a copy of this message
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

« previous php.general (#243971) next »