Tag Archives: MySQL

Append/Prepend string to a field in MySQL

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 , , , | Leave a comment

PDF output generating library using PHP

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 , , , , , , , , , , , , | 1 Comment

Concat multiple rows!

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 , , | 2 Comments

MySQL starting failed!

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 , | Leave a comment

PHP_SELF is empty!

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 , , , , , , | 6 Comments

MySQL problem

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

Posted in Troubleshooting | Tagged | Leave a comment