March 2010 - skunkworks - Skunkworks Site

IVRS expert
by Wamukunas Jim 04 Mar '10

04 Mar '10

Hi Where can I get a good IVRS(interactive Voice Response System) developer here in kenya. Just Reply urgently Regards

2 1

- call - Workshop on Internet Governance and Policies @ ICANN meeting in Nairobi, 11-12 March 2010 (RSVP)
by mwende njiraini 03 Mar '10

03 Mar '10

Dear colleagues, DiploFoundation is pleased to invite participants from ACP (Africa-Caribbean-Pacific) Group of States who are attending the ICANN meeting to register for a workshop on Internet Governance (IG) and Policies – “Internet Governance Diplomats”. The workshop will assist participants to grasp the multidisciplinary field of IG (including technical, legal, economic, socio-cultural and developmental aspects) and provide links with the international and regional processes (World Summit on Information Society and Internet Governance Forum). The discussions will also highlight the importance of IG and ICT issues and its effect on national and regional policies. *Time and Location:* March 11th and 12th (announcement and programme attached) Kenyatta International Conference Center, Nairobi * Registration:* Open to all stakeholders from ACP (Africa-Caribbean-Pacific) countries Limited to 30 participants on a first come basis Please send an email with your full name, country of residence, institution and position to: acpinfo(a)diplomacy.edu Deadline for applications: 5 March 2010 The workshop is a first event in a range of activities of the “Capacity Development in ICT Policy and Internet Governance for Africa – Caribbean – Pacific (ACP)” programme of DiploFoundation, with support of the European Commission and Secretariat of the ACP Group of States. For detailed info on this programme, please visit: www.diplomacy.edu/acp Looking forward to cooperating with you, Best regards, Vladimir Radunovic DiploFoundation

1 0

PHP/MySQL logic problem
by Peter Karunyu 03 Mar '10

03 Mar '10

Good evening skunks, I am retrieving the data below from a MySQL table, I want to display it on a page as follows: for any given day, I want to show the earliest time and the latest time, (for example, 2010-02-02 09:53:00 and 2010-02-02 10:50:00) on one row. In cases where there is only one entry for a given day ( for example 2010-02-01 08:55:00), I will show that entry as both the earliest time and the latest time, still on one row I am sure I can write more than one query which can use MIN() and MAX() and subqueries to retrieve the same, but I want to run the query once, retrieve all the data then apply logic in code to achieve the same. I had written some PHP code which works only until it encounters single entries but its too messy to post here, someone please help? 2010-02-01 08:55:00 2010-02-02 09:53:00 2010-02-02 09:54:00 2010-02-02 10:48:00 2010-02-02 10:50:00 2010-02-04 16:55:00 2010-02-05 17:29:00 2010-02-16 09:35:00 2010-02-16 18:10:00 2010-02-17 10:09:00 2010-02-18 11:28:00 2010-02-18 14:58:00 2010-02-19 09:31:00 2010-02-19 12:28:00 2010-02-19 12:33:00 2010-02-19 16:58:00 2010-02-22 09:40:00 2010-02-22 15:26:00 2010-02-22 15:31:00 2010-02-23 11:52:00 2010-02-24 10:41:00 2010-02-24 18:32:00 2010-02-25 11:38:00 2010-02-25 18:08:00 2010-02-26 11:00:00 2010-02-26 18:20:00

2 1

Re: [Skunkworks] PHP/MySQL logic problem
by Steve Obbayi 03 Mar '10

03 Mar '10

Hi Peter, Based on your table assuming the dates are stored in a column called 'mydate' and table called 'datetable' then you need to run a query similar to this then am sure you can handle the presentation in PHP: SELECT mydate AS given_day, EXTRACT(DAY FROM mydate) AS unique_days, MIN(mydate) AS earliest_time, MAX(mydate) AS latest_time FROM datetable GROUP BY unique_days; if you want to extract just the time and ignore the days then use this one: SELECT mydate AS given_day, TIME_FORMAT(EXTRACT(HOUR_SECOND FROM MIN(mydate)), '%H:%i:%s') AS earliest_time, TIME_FORMAT(EXTRACT(HOUR_SECOND FROM MAX(mydate)), '%H:%i:%s') AS latest_time, EXTRACT(DAY FROM mydate) AS unique_days FROM datetable GROUP BY unique_days; Cheers ;-) Steve Obbayi SKYPE: sobbayi http://sobbayi.com http://blog.sobbayi.com ----- Original Message ----- From: "Peter Karunyu" <pkarunyu(a)gmail.com> To: "Skunkworks forum" <skunkworks(a)lists.my.co.ke> Sent: Wednesday, March 3, 2010 10:43:18 AM GMT -05:00 US/Canada Eastern Subject: [Skunkworks] PHP/MySQL logic problem Good evening skunks, I am retrieving the data below from a MySQL table, I want to display it on a page as follows: for any given day, I want to show the earliest time and the latest time, (for example, 2010-02-02 09:53:00 and 2010-02-02 10:50:00) on one row. In cases where there is only one entry for a given day ( for example 2010-02-01 08:55:00), I will show that entry as both the earliest time and the latest time, still on one row I am sure I can write more than one query which can use MIN() and MAX() and subqueries to retrieve the same, but I want to run the query once, retrieve all the data then apply logic in code to achieve the same. I had written some PHP code which works only until it encounters single entries but its too messy to post here, someone please help? 2010-02-01 08:55:00 2010-02-02 09:53:00 2010-02-02 09:54:00 2010-02-02 10:48:00 2010-02-02 10:50:00 2010-02-04 16:55:00 2010-02-05 17:29:00 2010-02-16 09:35:00 2010-02-16 18:10:00 2010-02-17 10:09:00 2010-02-18 11:28:00 2010-02-18 14:58:00 2010-02-19 09:31:00 2010-02-19 12:28:00 2010-02-19 12:33:00 2010-02-19 16:58:00 2010-02-22 09:40:00 2010-02-22 15:26:00 2010-02-22 15:31:00 2010-02-23 11:52:00 2010-02-24 10:41:00 2010-02-24 18:32:00 2010-02-25 11:38:00 2010-02-25 18:08:00 2010-02-26 11:00:00 2010-02-26 18:20:00 _______________________________________________ Skunkworks mailing list Skunkworks(a)lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1… ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

2 1

cisco gurus - any bsci tips?
by francis kamau 03 Mar '10

03 Mar '10

Has anybody attempted bsci recently? share your experience

1 0

Kaspersky,Symantec,AVG or MCafee
by Lawrence kago 03 Mar '10

03 Mar '10

Hi Skunkers. Can anyone help me to choose between the CORPORATE edition of the above antivirus BASED on facts. Currently our organisation(over 30 users) is using symantec,however i am not sure this is the best option. I know Kav single user is 'prefect',is it the same for corporate version? -- If u have to take a rest,please do so, but never quit.. Lawrence Kago Computer Tech Free consultation.

9 11

DLP Projectors with WiFi
by Andrew Wachira 03 Mar '10

03 Mar '10

Hi, Does anyone know where i can get a DLP projector in town with WiFi like this one: Acer DLP projector with WiFi<http://www.itechnews.net/2008/06/12/acer-p5260i-wifi-dlp-projector/> The WiFi requirement is not that strict but if there are any around please let me know. Thanks ahead.

3 4

Re: [Skunkworks] Kenyan J2ME Mobile UI Library (Flemil)
by fyodor 03 Mar '10

03 Mar '10

Hi This is a lovely initiative. However, wouldnt it be great if this was open-source? you know have guys look at the libraries and stuff? Cuz in my humble opinion, this might just turn me to alternatives which are open-sourced. thanks. -tyrus

2 1

Developing A Website for a Training Institution
by Joseph McDonald 03 Mar '10

03 Mar '10

Good Day! Am consulting for some investors who want to set up a training institution. So am in process of getting a person/company who I can work with on a fixed price project to develop a website. I have attached the RFP. Sorry the timeline is crazy,I will evaluate the proposals and hoping to start working early next week. Thanks

1 0

Where to get MPEG-4 Digital Decorder
by Edward Obiko 03 Mar '10

03 Mar '10

Does anyone know where I can get the above decoder? The ones certified by the Ministry. Thanks Regards, -- OO Omingo Obiko

4 5