- skunkworks - Skunkworks Site

MySQL ASSISTANCE: UPDATE> INNER JOIN> WHERE
by Kibui Maina 01 Aug '11

01 Aug '11

Hi, I have a *MYSQL Update* Query where I need to use an *inner join* and * where* but its not working, any assistance will be highly appreciated. UPDATE jos_jreviews_content SET jr_soserviceareapopulation = NULL FROM jos_jreviews_content LEFT JOIN jos_content ON jos_content.asset_id=jos_jreviews_content.contentid WHERE jr_soserviceareapopulation =0 Rgds Kibui Kenneth Maina,* * * * *Tel:* +254 (0) 721 173 780 *Blog:* Opticom Solutions<http://opticomsolutions.blogspot.com/> *Website*: kit-b.com <http://www.kit-b.com> *Twitter:* @mainakibui<https://twitter.com/#%21/mainakibui> * * *Tools I Use:* Joomla, PHP, MYSQL, Learning Python, Amazon cloud hosting, WHM, Cpanel, Adobe CS4, Dreamweaver, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.

5 6

Web Designer with Wordpress Skills Needed
by David Mugo 01 Aug '11

01 Aug '11

Guys, Am looking for a web developer with Wordpress skills and basic Graphic Design (Photoshop or Fireworks) PHP, CSS & HTML knowledge. The said candidate needs to have creative skills and the ability to create crisp designs. Please forward CV to info @hostkenya.com The said candidate will work on a small retainer and a per project commission with a good turnout of projects each month. -- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax

1 0

Re: [Skunkworks] LAPTOP AT THROW AWAY PRICE
by TheBigBoss 30 Jul '11

30 Jul '11

Find below specifications and crappy pictures Got many emails for the laptop and since I have no idea of exact market value and I want to get most of it, I gonna start a silent auction :) 1/ Auction ends on Sunday, 8pm. Deal to be done next week Tuesday 2/ Best offer gets it. Will send email to winner, if no reply/no deal will send email to second winner, etc... 3/ Send your offer to my email address TheBigBoss(a)peperuka.com (subject "Presario") 4/ Minimum bid increment is 200 Kshs 5/ You can follow current bid on Twitter: http://twitter.com/Peperuka or search for #LaptopSaleKE => go there from time to time to see if you have been outbidded 6/ Serious offer only please. Cash only. Starting price 25000 Kshs Happy bidding ! **************** PRESARIO CQ62-219WM Intel Celeron Processor 900 (2.2 Ghz) 15.6" Diagonal LED High-Definition BrightView Widescreen 250 GB (5400RPM) Hard Drive 20248 MB DDR2 SDRAM Super Multi 8x DVD + R/RW with double layer support 6-cell lithium-ion battery Genuine Windows 7 Home Premium 64-bit 802.11 bgn TB WW No modem ***************** Note that I have no idea if Windows 7 is a trial period or not. If it is not, good for you; if it isn't, pole. Since it is still in box, I haven't tried it; so I can't you if it's operational or not but I guess it is !! I can deliver freely within CBD or Kilimani. Lastly, once sold, I'll give you one day to try it then consider it sold, no return. Thanks a lot !

4 7

website review on a redesign
by Gichingiri Kuria 30 Jul '11

30 Jul '11

Good afternoon people, Please give your comments on this redesign - www.sokoletu.com/sgc/ This is the before - www.strathmore.edu/governance/ Thanks -- Gichingiri Kuria _________________________________________ www.website.co.ke / www.sokoletu.co.ke

8 7

WIFI AROUND JUNCTION AREA NAIROBI
by The sherminator 30 Jul '11

30 Jul '11

Here is something i think might interest most of you.Courtesy of the Wananchi group in conjunction with Google. http://www.waziwifi.co.ke/index.htm

3 3

This fool should be jailed for life...
by Timothy Mutugi 30 Jul '11

30 Jul '11

Fellow Skunks, Some people should be jailed for life... I've just received the following SMS (from the number: 0704212127): --------------------- KENYANS FOR KENYA, Donations to M-PESA PayBill number 0704212127 to contribute towards famine relief in Kenya --------------------- Kenyans are dying of hunger and all this idiot can think of is to hoodwink people to send him m-pesa money meant for relief food... If there is a Safaricom skunk herein, please trace this fool and make sure he is taught a lesson he will never forget...

2 2

Re: [Skunkworks] [OT] Karura X-Country Marathon Live Streaming
by Ken Teyie 30 Jul '11

30 Jul '11

Sports live: Karura Cross Country Challenge live from the venue http://g4s-karurachallenge.com/

1 0

Airtel workers go on strike in Abuja over salaries, benefits
by mambo mutua 29 Jul '11

29 Jul '11

This is so sad guys. http://goo.gl/pKERq

14 15

Drupal to Wordpress migration
by Daudi Were 29 Jul '11

29 Jul '11

Good evening Skunks! Does anyone here do Drupal to WordPress migration? If so please get in touch with your rates. (Drupal family relax, we still respect you!) -- Ni Wakati! Pamoja! Daudi Were Digital Strategy Mobile: +254723553287 | Mail: daudi(a)were.co.ke Blog: http://mentalacrobatics.com | Skype: d.were Postal Address: P.O. Box 52218 Nairobi, Kenya, 00200

1 0

Combining two tables
by The sherminator 29 Jul '11

29 Jul '11

I have two table login_info_1,login_info_2 which has a column user_id in each table select user_id,count(user_id) as cnt from login_info_1 group by user_id; which gives me result like this user_id cnt 101 4 102 5 103 1 107 7 same for the second table select user_id,count(user_id) as cnt2 from login_info_2 group by user_id; user_id cnt 101 3 102 2 103 2 107 1 I want to combine these two tables and the results should look like this user_id cnt 101 7 102 7 103 3 107 2 Database: MYSQL

2 4