I know it's not so hard, but sometimes it just doesnt come to mind right away.
select column from table order by column desc limit 10;
It's handy if you want to show the 10 most viewd examples in a site like
this for example. I keep a track about the number of times each example is
viewd and give you an option to see the 10 most viewd examples.
berber
ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL,
Oracle, Interbase,ODBC, Microsoft Access and FoxPro. Categories : PHP Classes , Databases , PHP , General SQL , ODBC How to group by only by the date when you are really using a datetime type of field. Categories : Databases , MySQL , General SQL phpEasySQL - Easily connect to your MySQL database with just 1 php file and 3 easy steps! Categories : Databases , PHP , MySQL , General SQL Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL , Complete Programs , General SQL , PHP , Databases generic sql insert non-literal values Categories : General SQL , Databases google like search function with bolded search terms Categories : PHP , Search , Databases , General SQL You have a set of many resources , and You need to know wich of these resources are available for a given use during a given period but MySql does not allow SUB-Selection :(
here is the right way to do that in a single query
Categories : MySQL , General SQL , Databases , Algorithms Multiple Search using PHP and Mysql Categories : PHP , Databases , General SQL , MySQL This function will populate the options in a drop down HTML select list
in a form from a database query.
Categories : MySQL , General SQL , PHP , HTML and PHP , Databases Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0. Categories : Databases , PHP , mSQL , Databases explode() and SQL blobs Categories : General SQL , Strings , PHP , Databases Is there some possibility to link a database to an htaccess file, so that instead of having a passwd file you would have a database with DES-crypted password and username fields? Categories : Authentication , PHP , General SQL , Databases Persistent connections - General information. Categories : General SQL , PHP , Databases Compare NTEXT fields - a function (tested in SQL Server 2000) that can compare two NTEXT values for equality. Categories : MS SQL Server , Databases , General SQL TSQL INDENTER Categories : MS SQL Server , Debugging , Databases , General SQL