Here are the steps into setting up Sphinx for your Plesk sever through SSH. I'm running on CentOS 5.2 but I'm pretty sure these instructions work on most Linux environment. If you're looking to install Sphinx on WAMP (Windows machine) there's another article for that.
I recall the first time trying to setup Sphinx search on my Windows machine with Wamp it wasn't so obvious of how it was to be setup. Here's a guide in how to get it setup on you local machine. If you want to install Sphinx on Linux / Plesk there's an article for that too.
If you are just discovering the world of web development but know nothing about HTML code, css and mumble-jumble, here's a good place to start. In this article I will outline in general where to find resources and some good skills to pick up on to becoming a minor expert in the field.
Working with MySQL and PHP is awesome. Its one of the best way to manage your data, but once in a while you may want to do some randomizing. One problem I came across recently was how to select a random row from your MySQL table with PHP. Using the ORDER BY rand() method in your query maybe a bit slow so here's what we've got.
You are currently browsing the archives for the MySQL category.
