Tag Archives: MySQL

Append/Prepend string to a field in MySQL

Posted on August 30, 2009 by The HungryCoder

Just now I am working with a problem where I need to update a column/field by appending something. I was in a bit trouble for a 2 mins as I was finding a solution for this. First thing came to … Continue reading →

Posted in Tutorial | Tagged MySQL, query, tips, Update | Leave a comment

PDF output generating library using PHP

Posted on July 12, 2009 by The HungryCoder

If you are looking for creating PDF output of your HTML pages, you can do it using PHP’s PDFlib module. However, there are some libraries for faster development of your script. Some even are not dependent on PDFlib. Please see … Continue reading →

Posted in PHP, Scripts | Tagged dompdf, fpdf, html, html to pdf, MySQL, Open Source, PDF, PHP, phplib, Scripts, SQL, tcpdf, Web Services | 1 Comment

Concat multiple rows!

Posted on October 29, 2008 by The HungryCoder

Today I was wondering how can I concatenate multiple rows in a single row. Suppose, I need to get the email addresses of a user table. The “SELECT `email` FROM `usertable`;” will return something like this: email1 email2 email3 But … Continue reading →

Posted in Tutorial | Tagged Concat, MySQL, PHP | 2 Comments

MySQL starting failed!

Posted on September 16, 2008 by The HungryCoder

Today one of my junior friend asked me to help with his new VPS. He was in trouble that his mysql server was not starting up. After logging in the server, I saw the problem. It was showing: Timeout error … Continue reading →

Posted in Troubleshooting, Web Hosting | Tagged MySQL, VPS | Leave a comment

PHP_SELF is empty!

Posted on September 10, 2008 by The HungryCoder

Last two days, I am playing or learning to play with nginx web server. I have heard some reputation about it and saw some performance chart in the web. I liked it for its, as claimed, extremely low memory footprint … Continue reading →

Posted in Linux, Open Source, Tutorial, Web Hosting | Tagged centos, fastcgi, Linux, MySQL, nginx, PHP, php-fpm | 6 Comments

MySQL problem

Posted on September 22, 2007 by The HungryCoder

Today, I have to waste a long time with new server. Last night my internet connection disconnected while cPanel was installing in the server. Later I have seen that everything running fine except mysql. It is showing some error like:

Warning, no valid mysql.sock file found.mysql has failed

searching many tutorials, forums after 2/3 hours later I found the following post. http://forums.spry.com/showpost.php?s=06fff7fc89bd04e88fbdf1ecf60f4be1&p=2055&postcount=6

Continue reading →