unsharpTech

I feel that this should be brought to the attention of FileZilla users out there even though it may be a huge concern. (Lots of apps do this but potentially giving up FTP access info to a bunch of servers you are responsible for is something to be avoided). Jump to the Important Stuff

[Read the rest]

I’ve always had some trouble with the syntax for accessing Nested Arrays and their Keys in PHP so I wanted to make note of this.

[Read the rest]

Recently using osCommerce I had a customer who wished to have all the products’ names in uppercase but they had been entered in mixed case. After having some trouble finding a simple answer through Google, I pieced together this simple query that can also be adapted to other situations.

The below is a MySQL query to update all of the products’ names in an osCommerce catalog to uppercase - you can copy this into phpMyAdmin.

UPDATE products_description SET `products_name` = UPPER( `products_name` )

OR GENERICALLY:

UPDATE table_name SET `column_name` = UPPER( `column_name` )