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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
