Buy me a coffee
Spammers!
If you are going to put nonsense comments on my articles at least have the decency to click one of these adverts while you are here.
Even if you are a regular visitor you click a couple of ads while you are here - you might find something you want.
You May Also Like…
Cloud
accessibility block browser cache chrome chunk cms concrete5 CSS curl database date error file firefox form get href ie image input iphone javascript JQuery link magento MODx myqsl MySQL php post profile Revolution select Server session snippet spellcheck spelling table textarea tinymce w3c wordpress xmlInfo
Yes, the images are ambiguous;
Yes, they came from Google images;
No, I didn't get permission to use them*;
I know Magento called isn't Magneto;
And...
Why do spammers who hit this site do it with such a bizarre use of the English language?;
MySQL Archive
-
SQL Database of Countries and their ISO Codes
Posted on 16/02/2012 | No CommentsIt's useful to have a current list of countries for some projects with their ISO codes. This makes populating lists... -
Join the Same Table Twice in MySQL
Posted on 18/05/2011 | 1 CommentSometimes yo need to query the same database table twice in one query where the two rows have a common... -
Using concat to return 2 (or more) MySQL fields as one
Posted on 16/05/2011 | No CommentsIf you have field one and field two but need to return them as a single new field then you... -
Query JSON data stored in a MySQL Database
Posted on 16/05/2011 | 4 CommentsIf you are storing JSON information in a MySQL database and need to perform a query based on this then... -
Replacing information inside a MySQL database
Posted on 27/04/2011 | 1 CommentTo do a search and replace in any MySQL database in phpMyAdmin. You do not need to download the database... -
Mini version of phpMyAdmin
Posted on 11/03/2011 | 1 CommentphpMyAdmin can be a bit overkill for small queries on a MySQL database and if the db is 'localhost' and... -
Automatically add fields/columns to a MySQL database
Posted on 05/11/2010 | No CommentsTo take the fields from a form and build a database on the fly do the following: foreach($_POST as $var... -
Duplicate MySQL data from one table to another
Posted on 12/09/2010 | 9 CommentsTo copy all records from table one into table two (except record 1) use this: INSERT INTO table_two SELECT *... -
PHP MySQL Order by Two Columns
Posted on 17/05/2010 | No CommentsHere’s how to order by more than one column. When ordering by more than one column, the second column is... -
Getting a year from a MySQL timestamp
Posted on 30/04/2010 | 2 CommentsTo filter by a year when the date has been saved as a timestamp, do this. pub_date if the stored...