e-jamal :: Latest Technology

PHP & MySQL Interview Questions

2009-07-11T01:03:00.006+05:30

1. write a query to delete 3rd record from the below table.

table name: test_tbl

Please post your delete query in comment section.

MySQL Query Challenge1

2009-06-29T02:24:00.013+05:30

Table Name: contacts_tbl

Table Name: groups_tbl

Challenge :
make use of the above two tables and write the search query to list names of all persons belong to particular group

e.g., if I search for group 'Friends' it should list names of records 1,2,3,8,9,11,12,13 from contacts_tbl

post your query in comment section...

.

Ghajini (2008) First Promo - Aamir Khan's Psychic Thriller Movie

2008-10-28T23:57:00.010+05:30

Ghajini is the Hindi adaptation of the Tamil film Ghajini(2005) to be directed by A. R. Murugadoss. The film is inspired by the critically acclaimed film Memento by Christopher Nolan, with the common theme of the protagonist suffering from anterograde amnesia or short term memory loss and seeking revenge for his wife's murder. Ghajini will feature Aamir Khan, Asin Thottumkal and Jiah Khan in lead roles. A. R. Rahman will be scoring the music for the film whilst Ravi K. Chandran and Anthony handle cinematography and editing of the film respectively. The film began shooting in May 2007, with songs having been shot in the Deadpan Desert of Namibia and in Cape Town, South Africa. The movie is notable for Aamir Khan having shaven his head bald. A 3d game is reportedly being produced, the release of which will coincide with the audio release. The film is regarded as the most awaited Bollywood movie of 2008.

Ghajini has reportedly already made Rs 90 crore.

According to reports, the Indian Film Company has bagged the domestic distribution rights for Ghajini of an estimated Rs 53 crore. While its home video rights, overseas rights and satellite rights have been sold for another Rs 40 crore which brings to the grand total to Rs 93 crore.

New Mercedes Benz SCL 600

2008-08-02T21:12:00.007+05:30

This is the new Mercedes Benz SCL600.

This car is really different.

That's not what is different about it.

That either.

........and now for the 'really different' part:

Here is what is different.

No steering wheel, you drive it with a joystick. No pedals either.
Can you drive with a joystick?
The influence of video games in our lives has really arrived, wouldn't ya say?

sQuba - World's First Aqua Car

2008-02-15T20:29:00.003+05:30

A Swiss company called Rinspeed has recently announced its newest project: an underwater car. Named "sQuba," the car can both drive on roads, and then - at the push of a button - dive up to 10 meters (33 feet) under the sea.
Rinspeed describes sQuba as the world's first real car to drive both on land and underwater, thanks to some cutting-edge technology. The car has a steel chassis, while its lightweight body panels are made of carbon nanotubes.

An electric motor provides rear-wheel drive while on roads. Underwater, two propellers in the stern and two jet drives in the bow propel the "amphibious" vehicle. With zero emissions, the design is even environmentally friendly, eliminating any pollution into the sea.

The two-seater also includes a self-contained on-board oxygen system to supply the driver and passenger with fresh air for breathing.

The sQuba's top speed on land is about 77 mph, but it slows down to 3 mph on the surface of the water, and 1.8 mph underwater.

Rinspeed CEO Frank Rinderknecht admits that part of the inspiration for the underwater car comes from the 1977 James Bond hit "The Spy Who Loved Me." The sQuba concept symbolizes the realization of this fantasy that once sparked his imagination.

"And exactly thirty years later this amazing - yet at the time animated - film sequence materializes and becomes reality, in today's world," said Rinderknecht.

The sQuba car will be presented at the Geneva Motor Show, which runs from March 6-16, 2008. However, mass-production of the car is not planned for the foreseeable future.

Swiss Company Creates Underwater Car | ‘fly’ under water

Cyber Criminals sniffing your inbox!

2008-02-08T03:18:00.000+05:30

"CONGARTULATION: YOUR EMAIL ADDRESS EMERGED AS A WINNER IN 2008 AWARD PROMO!!!"
"PRIZE APPROVAL NOTICE"
"Office of Prize Disbursement (OPD)"
"Attn: Lucky Winner"
"£2,500,000.00 Great British Pounds"

Beware of mails with similar kind of subject lines!

Currently, there are several versions of fraudulent e-mails being circulated which purport to be from Yahoo, Microsoft, AOL, BMW... These e-mails advise the recipient that he or she has won money or a car and requests the recipient to provide personal data or to pay a fee in order to receive the prize.

sample prize notification mail

As I experimented thoroughly with providing my fake personal information to cyber criminals and would like to confirm that these e-mails are NOT authentic. The e-mails have NOT been sent by Yahoo or Microsoft or AOL or BMW or any authentic organization, nor has any organization authorized the use of its name. Please be advised not to provide any personal information or transfer money
to the perpetrators. Any personal information provided to the perpetrators will likely be used for illegal purposes.

perpetrator requesting me to pay courier

charges for the final delivery of cheque

1,000,000.00 (One Million Great Britain Pounds)

and other documents

Microsoft offers to buy Yahoo for $44.6 billion

2008-02-01T19:09:00.000+05:30

7:01 PM Feb-1-2008

Microsoft Corp. Friday said offered to buy Yahoo Inc. for $44.6 billion, or $31 a share, in a mix of cash and stock.

The offer represents a 62% premium on the $19.18 closing price of Yahoo on Thursday.

The software giant said the deal would create a more efficient company with total annual synergies of $1 billion, driven by audience critical mass, increased value for advertisers and operational efficiencies.

Microsoft said it has already developed a plan to involve both companies' employees in the integration, and said it would offer significant retention packages to Yahoo engineers and key leaders.

Microsoft said it expects a deal to get regulatory approval and to be completed in the second half of 2008.

Microsoft noted that it is targeting the fast growing online advertising business, which the company estimates will double to $80 billion by 2010 from $40 billion in 2007.

By teaming up with Yahoo, Microsoft gains critical edge in a fast-growing market and positions itself to help lead the possible consolidation of a sector that is beginning to impact all forms of commerce.

"Our lives, our businesses, and even our society have been progressively transformed by the web, and Yahoo has played a pioneering role by building compelling, high-scale services and infrastructure,' said Ray Ozzie, chief software architect at Microsoft.

"The combination of these two great teams would enable us to jointly deliver a broad range of new experiences to our customers that neither of us would have achieved on our own," Ozzie added.

In his letter to Yahoo, Microsoft's Ballmer confirmed that the company had previously made overture to the Internet giant, which spurned the offer on the basis that the timing wasn't right then.

Ballmer also indicated that Microsoft's purchase offer would help Yahoo counter the aggressive moves that have propelled Google to the top of the field.

"While online advertising growth continues, there are significant benefits of scale in advertising platform economies, in capital costs for search index build-out, and in research and development, making this a time of industry consolidation and convergence," Microsoft said.

"Today, the market is increasingly dominated by one player who is consolidating its dominance through acquisition," Microsoft said. "Together, Microsoft and Yahoo can offer a credible alternative for consumers, advertisers and publishers."

US STOCKS-Futures gain as Microsoft aims to buy Yahoo | Microsoft offers to buy Yahoo for $44.6 bln | Microsoft targets Yahoo! with $44.6bn bid

U.S. spy satellite may crash into Earth

2008-01-28T20:04:00.000+05:30

A large U.S. spy satellite has lost power and propulsion and could hit the Earth in late February or March, government officials said Saturday.

The satellite, which no longer can be controlled, could contain hazardous materials, and it is unknown where on the planet it might come down, they said. The officials spoke on condition of anonymity because the information is classified as secret.

The spacecraft contains hydrazine - which is rocket fuel - according to a government official who was not authorized to speak publicly but spoke on condition of anonymity. Hydrazine, a colorless liquid with an ammonia-like odor, is a toxic chemical and can cause harm to anyone who contacts it.

John Pike, a defense and intelligence expert said it's not likely the threat from the satellite could be eliminated by shooting it down with a missile, because that would create debris that would then re-enter the atmosphere and burn up or hit the ground.

Pike, director of the defense research group GlobalSecurity.org, estimated that the spacecraft weighs about 20,000 pounds and is the size of a small bus. He said the satellite would create 10 times less debris than the Columbia space shuttle crash in 2003. Satellites have natural decay periods, and it's possible this one died as long as a year ago and is just now getting ready to re-enter the atmosphere, he said.

The largest uncontrolled re-entry by a NASA spacecraft was Skylab, the 78-ton abandoned space station that fell from orbit in 1979. Its debris dropped harmlessly into the Indian Ocean and across a remote section of western Australia.

In 2000, NASA engineers successfully directed a safe de-orbit of the 17-ton Compton Gamma Ray Observatory, using rockets aboard the satellite to bring it down in a remote part of the Pacific Ocean.

In 2002, officials believe debris from a 7,000-pound science satellite smacked into the Earth's atmosphere and rained down over the Persian Gulf, a few thousand miles from where they first predicted it would plummet.

Defunct spy satellite may crash into Earth | Orbiting U.S. spy satellite could crash to Earth | Disabled Spy Satellite Threatens Earth | Broken Spy Satellite May Crash to Earth

IPL coup gets BCCI richer by Rs 7000 crore

2008-01-25T00:54:00.001+05:30

The BCCI-powered Indian Premier League's(IPL) franchises on Thursday sold out with Bollywood stars, entrepreneurs and business houses alike pumping in as much as Rs 7,000 crore for its eight teams.

IPL team owners:

Mumbai - Mukesh Ambani - $111.9 million

Bangalore - Vijay Mallya - $111.6 million

Chennai - India Cement - $91 million

Delhi - GMR Holdings - $84 million

Mohali - Preity Zinta, Ness Wadia - $76 million

Kolkata - Shahrukh Khan - $75.09 million

Jaipur - Emerging Media - $67 million

Hyderabad - Deccan Chronicle - $107.01 million

The league is scheduled to start in April 2008 and will last for 44 days, involving 59 matches. The prize money for the league will be around Rs 13 crore (US $3million).

Each team will have a pool of 16 players, of whom four will be international and four from the Under-19 level or from the catchment area where the team is based.

Sony Television network and Singapore-based World Sports Group secured the rights of the IPL. The record deal has a duration of ten years at a cost of US$1.026 billion.

The following cricketers have already committed to the IPL:

India: Ajit Agarkar, S Badrinath, Piyush Chawla, Mahendra Singh Dhoni, Rahul Dravid, Gautam Gambhir, Sourav Ganguly, Wasim Jaffer, Mohammad Kaif, Dinesh Karthik, Murali Kartik, Zaheer Khan, Anil Kumble, VVS Laxman, Munaf Patel, Parthiv Patel, Irfan Pathan, Yusuf Pathan, Ramesh Powar, Suresh Raina, Virender Sehwag, Joginder Sharma, Rohit Sharma, Harbhajan Singh, RP Singh, Yuvraj Singh, Sreesanth, Sachin Tendulkar, Robin Uthappa.

* Rahul Dravid (rumoured to captain the Bangalore Franchise)
* Sourav Ganguly (rumoured to captain the Kolkata Franchise)
* Sachin Tendulkar (rumoured to captain the Mumbai Franchise)
* Yuvraj Singh (rumoured to captain the Mohali Franchise)

Australia: Shane Warne, Glenn McGrath, Justin Langer, Ricky Ponting, Adam Gilchrist, Andrew Symonds, Michael Clarke, Michael Hussey, Brett Lee, Matthew Hayden, Nathan Bracken, Brad Haddin, Mitchell Johnson, Simon Katich, Jason Gillespie, Cameron White.

Pakistan: Shoaib Malik, Mohammed Yousuf, Shoaib Akthar, Younis Khan, Mohammed Asif, Shahid Afridi.

Sri Lanka: Mahela Jayawardene, Muttiah Muralitharan, Chaminda Vaas, Lasith Malinga, Nuwan Zoysa, Sanath Jayasuriya, Kumar Sangakkara, Farveez Maharoof, Dilhara Fernando.

South Africa: Graeme Smith, Ashwell Prince, Herschelle Gibbs, Albie Morkel, AB de Villiers, Shaun Pollock, Loots Bosman, Jacques Kallis, Makhaya Ntini.

New Zealand: Stephen Fleming, Brendon McCullum, Jacob Oram, Daniel Vettori, Scott Styris.

West Indies: Shivnarine Chanderpaul, Ramnaresh Sarwan, Chris Gayle.

Mystery of Red Planet Picture

2008-01-23T19:26:00.000+05:30

It's the picture that ET believers have been waiting for - and the one that shows there could be life on Mars.

The image, taken by Nasa's Mars Explorer Spirit, seems to show a figure on the surface of the red planet.

However the more sceptical have decided that it is just a rock.

At first astronomers were disappointed with pictures sent back from the surface of the Red Planet by the six-wheel robot four years ago.

But a space fan spotted the figure, which was just a pinprick in the original photograph. It was blown up and posted on a website.

NASA captures alien figure | Nasa captured a female alien| life on Mars

MacBook Air - World's thinnest notebook

2008-01-17T11:24:00.001+05:30

Apple has unveiled the world's thinnest laptop, called the MacBook Air.

ultrathin, ultraportable, and ultra unlike anything else
MacBook Air is 0.76 inches(1.93cm) at its thickest point
costs from $1,799 in the US (£1,199 in the UK)
comes with either an 80 Gigabyte hard disc drive as standard or 64 Gigabyte solid state drive for an added $999
1.6GHz or 1.8GHz Intel Core 2 Duo processor
2GB of RAM built in
Built-in iSight camera
802.11n Wi-Fi and Bluetooth 2.1 + EDR built in

Get

Animating an Indian Superstar

2008-01-14T13:04:00.001+05:30

Adlabs and Ocher Studio revealed the first look of their 3D animated mega-production sultan - the warrior featuring superstar Rajnikanth.

This is the first time in India that a superstar is being animated. Sultan the warrior will leature Rajnikanth as a mythological, larger-than-life hero in a gripping action adventure film and will be replete with the stylized Rajnikanth mannerisms and punch lines for which is known and loved. The film is targeted at adults as well as kids, both in India and the rest of the world.

Starting : Rajnikanth
Director : Soundarya Rajnikanth
Music Composer : A R Rahaman
Release Date : January 14, 2009

Trailer | Download Posters

official website | After Robo, Rajini gets animated over Sultan| Wikipedia | CNNIBN

Tata's Promise is a Promise

2008-01-10T12:51:00.000+05:30

BDV-164603-BDV
1:08 PM 10-Jan-2008
Ratan Tata unveils what is perhaps the most-hyped four-wheeler of the year at the Auto Expo show in New Delhi. 'Nano' is priced at Rs 1 lakh, excluding taxes.

Tata unveils long awaited people's car
Tata's Small car is called Nano
Nano is the world's cheapest car
Nano to be powered by 624cc engine
Nano will have 33 BHP
Nano will have a 30-litre fuel tank
four-speed manual gearshift
Nano to give a mileage of 23Kmpl
Nano is smaller than Maruti 800
Nano will be 21% larger than Maruti 800 from inside
Nano will have a dealer price of 1 Lakh
Nano cost half of the price of its competitors
The car has passed all safety test
Nano will be available in three models
Basic model is not air-conditioned
One Nano model will be air-conditioned

Watch Video 1

Watch Video 2

Tata's another revolution... definitely a Nightmare for its competitors!

Gtalk multi-user login!

2008-01-07T19:10:00.010+05:30

Follow these simple steps to login Google talk with multiple user accounts. You can be online with n number of user names.

* Create a shortcut of your Google talk.
* Right click the shortcut ---> choose Properties.
* In the "Target" you will find this

Assuming you have installed in C:

* Now at the end of target add this "/nomutex" without the quotes.
* It should be like this

Thats it. Click OK and you can open more than one Google talk.

Amazing 3D Rendering Technology

2008-01-07T15:07:00.000+05:30

Another amazing innovation from Japanese. YouTube video shows a real time 3D rendering technology which can convert your face into real 3D avatars with variety of styles...

Related Video : Amazing 3D rendering technology

Ultimate trick to boost your internet speed!

2007-12-29T02:37:00.000+05:30

OpenDNS is a free DNS resolution service. It provides two recursive nameserver addresses for public use, mapped to the nearest operational server location by Anycast routing:

How it works?

OpenDNS is the world's most intelligent DNS service. Its global network and its software work together symbiotically to offer a set of features custom-tailored to you, without requiring you to buy any hardware or install any software.

OpenDNS has servers situated strategically at the most well-connected intersections of the Internet. Unlike your ISP, its network uses Anycast routing technology, which means no matter where you are in the world your DNS requests are answered by OpenDNS closest datacenter. Anycast routing also means that you are automatically routed to OpenDNS next closest datacenter in the event of maintenance or downtime. This makes your Internet faster and more reliable.

Some Important Features

Phishing Protection

Phishing, or using phony websites to trick people into handing over their personal information, threatens everyone who spends time online. (Definition...) OpenDNS phishing protection is designed to keep everyone on your network safe from phishing scams and let you browse the Web confident you won't be fooled.

OpenDNS operates and uses Phish Tank, the Web's most trusted source of phishing data. PhishTank is so good, Yahoo! Mail uses its data to protect all account holders. The site works by having real people look at suspected phishing scams and verify their legitimacy.

PhishTank has verified more than a quarter of a million phishing scams. They pass the intelligence straight on to you and protect everyone on your network.

Typo Correction

OpenDNS don't think you should be punished with an annoying error message if you make a small typo, like typing google.cmo instead of google.com. OpenDNS correct it and opens you the expected website!.

How does openDNS make money?

OpenDNS earns a portion of its revenue by sending the user to an OpenDNS search page when a domain name that he has entered is not valid. Advertisements are displayed on this search page to help fund the operations of OpenDNS. While this behavior is similar to VeriSign's previous Site Finder, OpenDNS states that it is not the same, as OpenDNS is purely an opt-in service (compared to Site Finder's effect on the entire Internet, as VeriSign is an authoritative registry operator)and that the advertising revenue pays for the customized DNS service.

According to OpenDNS, additional services that run on top of its enhanced DNS service will be provided, and some of them may cost money

Get Started

Adidas Football Manufacture

2007-12-28T17:08:00.000+05:30

Adidas Football Manufacture

Love 2008

2007-12-28T16:28:00.000+05:30

Love 2008 - Wonderful Sand Art

Convert Pictures into ASCII Text Images

2007-12-27T23:38:00.000+05:30

Convert Pictures into ASCII Text Images

Benazir Bhutto assassinated

2007-12-27T19:28:00.000+05:30

7:28 PM 12/27/2007

PPP leader Benazir Bhutto has been shot dead following a suicide attack on her rally in Rawalpindi.

Pakistan interior ministry had earlier declared a high alert across the country post the attacks that marred rallies of both main opposition leaders, Nawaz Sharif and Benazir Bhutto.

The blast occured minutes after Benazir Bhutto finished her speech.

''We are traumatised. People all over are crying. Everyone is saying that this Army has killed Benazir. There is going to be more bloodshed. Will the world now finally wake up? said a distraught Asma Jehangir, Chairperson, Pak Human Rights Commission.

According to reports, 20 people have been killed and 42 others injured in the attack.

PPP Information Secretary Sherry Rehman has also been injured in the attack and taken to a hospital.

National and provincial assembly elections in Pakistan are due on January 8.

In October some 130 people were killed in an attack on Bhutto's cavalcade when she returned to the country.

It was one of the worst incidents of violence in a year of deteriorating security in Pakistan.

5 Steps to Home Wireless Security

2007-12-26T15:15:00.001+05:30

Just Like Locking Your Home
Just as you secure your home by locking your doors and windows, you must take the precaution of securing your wireless network by locking it down. By changing
. your router’s default administrator password
. changing the default SSID and disabling SSID broadcast
. changing your IP address settings
. setting up your router to use encryption
. using the MAC address filter
you can easily secure your home wireless network. Although these steps won’t prevent a dedicated intruder who’s intent on hacking your network, they’ll keep most malicious users and eavesdroppers away. more...

Automated Home Management

2007-12-26T15:12:00.000+05:30

Imagine walking into your kitchen and having the lights turn on automatically. Think about the energy you could save if your blinds and lighting automatically adjusted for the amount of sunlight entering your home. CasaWorks, a division of Metrics Technology, announced the Cielo Home Management System, a hardware- and software-based solution that offers these and other functionalities.

The Cielo Home Management System lets homeowners control household electronics including lighting, climate, security, and entertainment systems using PDAs, tablet PCs, Webpads based on Windows XP and Windows CE .NET, programmable remote controls, and PCs running Windows XP or Windows 2000. Cielo uses cameras, motion detection, and object tracking to sense the occupation and movement of users in the home. After sensing the movement of users, the technology modifies temperature, humidity, light level, and other environmental factors. You can also configure the product to automatically adjust lighting and environmental factors such as temperature for when the house is occupied and unoccupied.

In addition, Cielo can control security panels. Users can select home and away arming modes from any supported user interface and Cielo will monitor user access and send an e-mail notification when the system is armed or disarmed. Cielo provides biometric interfaces including face recognition and support for fingerprint readers so you can activate access control and personalized home behaviors based on recognition of each user. CasaWorks expects a late spring or early summer release of the Cielo, which costs $2500 to $7500, depending on hardware and software configuration.

More Than Half of Microsoft's Employees Opt for Options Payout

2007-12-26T15:09:00.000+05:30

When Microsoft made the historic decision to grant employees options on their otherwise worthless stock earlier this year, more than half of them elected to sell, netting more than 18,500 employees a total of $382 million in cash. Microsoft will distribute the first part of the payout, or about $218 million (an average of $11,782 per employee), this month, the company says. I find it curious that almost half of the company's employees didn't sell their options--a sign, financial analysts say, that those employees believe Microsoft's stock price will again rise to its earlier formidable levels. "We're pleased with the outcome," a Microsoft spokesperson said. "We believe it illustrates a great balance between employees who utilized the program and those who chose not to." This event also illustrates that the day of the "Microsoft Millionaire" is over, presumably.

Apple's iLife '04

2007-12-26T14:58:00.001+05:30

At Macworld San Francisco 2004 last month, Apple Computer CEO Steve Jobs introduced the company's latest suite of multimedia tools, dubbed iLife '04. Apple markets the $50 product as being "like Microsoft Office for the rest of your life," which is a cute way of saying that you'll need the lifestyle applications in this suite as much as you need products such as Microsoft Word and Microsoft Excel at work. Although iLife '04 isn't perfect, it's a stunning value for the money and a must-have purchase for every Mac OS X user. And if you aren't running Mac OS X, fear not: I also explore some related offerings for PC users.

Apple iLife '04 includes five brilliantly integrated applications, and at least three of them are best of breed:

iTunes 4: digital music organization, sharing, and iPod integration
iPhoto 4: digital photo organization, sharing, and basic editing
iMovie 4: digital video editing and sharing for home movies
iDVD 4: DVD movie creation
GarageBand: new to this version, a music-creation application with limited appeal. more...

How About Online Backup?

2007-12-25T14:49:00.000+05:30

Several hundred million PCs around the world aren't being backed up regularly. Chances are, you're one of the culprits. If and when some kind of disaster strikes, you're going to wish you had some kind of backup regimen in place. Putting together your own backup system can be a chore. Have you ever considered online backup?
Carbonite 3.0 is a simple online backup service. You simply enter your email address and password, and Carbonite does the rest. All data is backed up by default, and you have unlimited storage capacity, so there's no need to pick and choose files. "It's truly a product you won't be afraid to give to your most computer-illiterate friends and colleagues," said David Friend, Carbonite's CEO. "Release 3.0 is by far the simplest online-backup solution on the market today, and our beta testers have been delighted with its clean, easy, and intuitive qualities." more...