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 attributes block browser chrome cms concrete5 CSS curl database date error file firefox form get google href ie image input iphone javascript JQuery link magento MODx myqsl MySQL php post Revolution select Server session snippet spellcheck spelling table textarea tinymce twitter 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
-
Run MySQL in Apple OS X
Posted on 12/07/2012 | No CommentsOnce installed to get MySQL running on OS X you need to do the following: Launch the Terminal and type... -
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... -
MODx Easy 2 Gallery table structures
Posted on 18/03/2011 | No CommentsThe database tables used by Easy 2 Gallery are: modx_easy2_comments id, file_id, author, email, ip_address, comment, date_added, last_modified, status, read,... -
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... -
Google Chrome and PHP images
Posted on 20/05/2010 | No CommentsWhen sending PHP images (from a database/blob) to Chrome there are problems for the image loading. After lots of digging... -
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... -
MODx table structures, updated
Posted on 18/02/2010 | No Commentssite_content (green = new to Revolution) id, type, contentType, pagetitle, longtitle, description, alias, link_attributes, published, pub_date, unpub_date, parent, isfolder, introtext... -
MySQL escape String (mysql_real_escape_string)
Posted on 09/02/2010 | No CommentsEscapes special characters in the unescaped_string, taking into account the current character set of the connection so that it is...