mysql
MYSQL add counter in a query
Use mysql variables to create a counter in SQL, PHP code to use an SQL counter and what does the i mean in mysqli?
MySQL fulltext search always empty
If you’ve just switched to FULLTEXT indexes and you’ve just started playing with MATCH... AGAINST syntax, but you always get…
How to remove custom fields from WordPress
Ok. You’ve added custom fields in wordpress, but how can you remove them? How to delete custom fields wordpress Two…
13 mysql tips that you don’t know
Here is a list of thirteen tips that can be usefull for your queries. If you know more tips send…
PHP function to fix collation on database fields of MySQL
This PHP function search for tables in the active db, match table’s name with the regular expression passed as first…
10 PHP usefull functions for MySQLi stuff (mysql improved)
I’ve modified the previous post to use mysqli instead of mysql. Was it necessary? I think it was good step…
10 PHP usefull functions for MySQL stuff
Here is my personal collection of 10 php function that I always include in my database function library. I think…
Using REPLACE in an UPDATE statement to fix data on MSSQL and MySQL
Sometimes it’s necessary fix data on the database. I had to fix on a Microsoft database: I had to fix…
PHP to get enum/set values from mysql field
This function returns an array with the elements allowed in a ENUM or SET mysql field. This can be usefull…
Stop UTF8 problems with special characters
I’m italian and I always need to use special chars like è é à ù. The same need belongs to…
Execute Scalar and Execute Row for Php
A couple of simple functions thar returns the first value and the first row of a result set. Very usefull.…