Get ranking result with only one sql query

SET @rownum := 0; #Create counter variable
SELECT *
FROM
(
SELECT DISTINCT(memid), @rownum := @rownum + 1 as ranking
FROM dbname.table
WHERE
somesearchcondition = ‘12′
)

During the past several decades, the m …

During the past several decades, the media landscape has evolved into a complex and dynamic conglomeration of both traditional and interactive media that seek to serve the needs of today’s fast-paced lifestyles. While traditional media struggle under the weight of increased segmentation, the interactive environment provides the capacity to capitalize on this fragmented market by offering niche media vehicles that give consumers a voice amidst the whirlwind of information and advertising. In the online world, these niche media markets increasingly are driven less by publishers and more by user-generated content (UGC). User-generated content refers to media content created or produced by the general public rather than by paid professionals and primarily distributed on the Internet. Although the creation and dissemination of content has been a constant for hundreds of years, the potential for an ordinary consumer to communicate with and influence a mass audience was only recently put within reach given the advent of Web 2.0 technologies. Examples of prominent Web 2.0-based Web sites that support the creation and consumption of UGC include YouTube, MySpace, Facebook, Wikipedia, StupidVideos, Flickr, Blogger, and personal Web pages, among many others.

With the explosion of Web 2.0 technologies, UGC creates a plethora of niche markets within the media landscape that attract more than 69 million users and generate more than $450 million in advertising revenue (Verna 2007). As a result, the online information market continues to shift toward a user-centric model and away from the conventional media model, characterized as publisher-centric. Consumers today are active and in charge of their media experiences, making it more important than ever to understand motivational factors that drive media consumption (McQuail 2000). This power shift challenges media theorists to change the way they traditionally have identified audiences, with a lesser focus on examining the theoretical effects of media and a greater focus on understanding why and how consumers use media (Severin and Tankard 1992). Thus, it is imperative for researchers to gain a better understanding of the impact of UGC within the media environment, specifically why users create such content. To date though, little research has investigated UGC among either the users or the creators of this type of media. In response, this exploratory study examines the core relationship between a consumer’s motivational sources for creating UGC and how these sources affect perceptions of UGC.

Social Networking & “Corporate Web 2.0″ for Fender Music at the Winter NAMM “2007″ Front Line Live stage, on the show floor. This is a new start for Fender on the internet. We call it Corporate Web 2.0 meet the music business.

Copyright Note:
1. An artical from http://www.jiad.org/
2. An image about Yahoo Model from www.readwriteweb.com
3. Youtube Video by BillGanz62
4. An image from www.awarenessnetworks.com

Several ways to execute a shell script in Perl

There are several ways to execute a shell script in Perl :

#!/usr/bin/perl -w

use Shell qw(cat ps cp df ssh su);
print "Content-type: text/html; charset=Shift_JIS\n\n";

su ("neededuser");
@result = qx{ sudo su username -c '/home/perl/cgi-bin/CheckMailStatus.sh' };

$cmd = "sudo su neededuser -c '/home/perl/cgi-bin/CheckStatus.sh' ";
$data = qx/$cmd/;

$result = system ("sudo su username -c 'echo hello '");
print $data;

exit;