Manually Inserted Row
| From: | Keith Spiller | 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