Some days ago I was working in a quiz project. Where user will play quiz and for each correct answer they will earn points. One of the task of this quiz application was, to get rank of a particular user. Now I am showing how could I solve this problem using mysql query.

Here is the table structure:

CREATE  TABLE IF NOT EXISTS `quiz_user` (
`uid` BIGINT UNSIGNED NOT NULL ,
`participated` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`correct` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`wrong` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`created` DATETIME NULL ,
`updated` DATETIME NULL ,
PRIMARY KEY (`uid`) )
ENGINE = InnoDB

This table contains user records of quiz game. Here is an examples:

If you have been reading the Kontrollbase performance reports and noticed that one alert says your connection usage vs max connections ration is too high but then recommends you to decrease the max_connections variable, then you will find this fix handy. Its two simple queries that execute on the Kontrollbase schema to update the max_connections [...]

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.10

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 9.10 server with PHP5 support (through FastCGI) and MySQL support.

Amazon Simple Storage Service is designed to make web-scale computing easier for developers. If you have a medium to high traffic web application then S3 will help you to load your content faster. Here contents may be files, photos, videos or even text. Normally S3 is used for files, photos and videos. It gives any developer access to the same highly scalable, reliable, fast, inexpensive data storage infrastructure that Amazon uses to run its own global network of web sites.

3 months ago I developed a project for one of my client using Zend Framework. 1 week ago he told me to change the photo uploading system from hosting disk to amazon s3. Yesterday I implemented s3 for him and found its really very easy using Zend framework.

Here I’m describing how did I do so:

If you want to access S3 you’ve to signup in amazon s3 and need …

Installing Lighttpd With PHP5 And MySQL Support On Mandriva 2010.0

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Mandriva 2010.0 server with PHP5 support (through FastCGI) and MySQL support.

Am kommenden Donnerstag, den 11.02.2010 findet wieder ein öffentlicher Vortrag im Mayflower Büro in Würzburg statt (Pleichertorstrasse 2, 97070 Würzburg, Straßenbahn und die Haltestelle Congress Centrum).
Beginn ist um 18:00 Uhr, Thema des Vortrags ist "Praktische Anwendung von MySQLDumper".

Intelligentes Backup-Management bei MySQL-Datenbanken? Kein Problem, denn mit dem MySQLDumper kann jeder Sicherungskopien seiner wichtiger Datenbestände erstellen - und bei Bedarf auch kinderleicht wieder herstellen. Daniel Schlichtholz zeigt wie MySQLDumper einem das Leben erleichtert. Frei nach dem Motto: back it up the easy way...

Die "Donnerstags-Vorträge" werden sowohl in Würzburg als auch in München gehalten. Bei Interesse einfach das Blog beobachten, um auf dem Laufenden zu bleiben!
Wir freuen uns auf viele Teilnehmer!

…

Am kommenden Donnerstag, den 11.02.2010 findet wieder ein öffentlicher Vortrag im Mayflower Büro in Würzburg statt (Pleichertorstrasse 2, 97070 Würzburg, Straßenbahn und die Haltestelle Congress Centrum).
Beginn ist um 18:00 Uhr, Thema des Vortrags ist "Praktische Anwendung von MySQLDumper".

Intelligentes Backup-Management bei MySQL-Datenbanken? Kein Problem, denn mit dem MySQLDumper kann jeder Sicherungskopien seiner wichtiger Datenbestände erstellen - und bei Bedarf auch kinderleicht wieder herstellen. Daniel Schlichtholz zeigt wie MySQLDumper einem das Leben erleichtert. Frei nach dem Motto: back it up the easy way...

Die "Donnerstags-Vorträge" werden sowohl in Würzburg als auch in München gehalten. Bei Interesse einfach das Blog beobachten, um auf dem Laufenden zu bleiben!
Wir freuen uns auf viele Teilnehmer!

…

Installing Nginx With PHP5 And MySQL Support On Fedora 12

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 12 server with PHP5 support (through FastCGI) and MySQL support.

My apologies to Ron Burgundy for the title of the post, but I’m just a fan of the wisest man to ever live.

As Marco and Illia and countless others have said, unless you don’t work with PHP or were in a coma, Facebook released HipHop for PHP , it’s open source, it’s awesome, it makes you go fast. It’s not for you. You, being the average PHP developer, systems administrator, hacker. …

We have a new users’s group on Brijj for anyone that wants to keep up to date with discussions and wants to increase their network profile on the site. Join now: http://www.brijj.com/group/kontrollbase-users