- 1. URL Alias uniqueness with PHP & MySQL
- / Personal Home Page /
- ... url_counter); set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can ...
- Created on 06 May 2019
- 2. Convert to Proper Case in T-SQL
- / Transact-SQL /
- What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
- Created on 04 June 2014
- 3. PHP: First name and Initial of Surname
- / Personal Home Page /
- ... output echo $author_name_disp; A lot of repetition so lets reduce that a touch: // default $author_name_disp=$author_name; // check and transform $delimiters=array(' ', '.'); foreach($delimiters ...
- Created on 27 March 2014
- 4. Getting the mysql where in delimited string to work
- / MySQL /
- ... this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for ...
- Created on 02 January 2012