Adding Facebook Icon to Zen Cart

To add Faceook Icon to right side of template page, edit the tpl_main_page.php located in includes/templates/template_default/common/ directory. It can be added right below the following comments: /**  * prepares and displays right column sideboxes  *  */

Date
Categories
Tags
Comments

mysql how to add an Id column using auto increment

alter table tablename add column id int auto_increment primary key;

Date
Categories
Tags
Comments

Published:February 9, 2010 View Post

portland web design

Leave a comment

uppercase first character of every word in string

php string function ucwords();

Date
Categories
Tags
Comments

Published:February 8, 2010 View Post

portland web design

Leave a comment

How to uppercase first letter in each word

php function  ucfirst();

Date
Categories
Tags
Comments

how to copy files in php – the copy() function

copy(“originalfile.php”, “newfile.php”);

Date
Categories
Tags
Comments

Published:January 25, 2010 View Post

PHP

Leave a comment

How to lower case a column in mysql

update cityfn set city = LOWER(city);

Date
Categories
Tags
Comments

Published:January 24, 2010 View Post

MySQL

Leave a comment

How to remove characters or string from a mysql table

update tablename set column_name = replace(column_name, ‘find string to replace’, ‘replace with this string’); Forr example, if you have asterisks in your data you want to delete: update cities set city = replace(city, ‘*’, ”);

Date
Categories
Tags
Comments

Published:January 24, 2010 View Post

MySQL mysql tips

Leave a comment

How to copy records back into original table

insert into oldtable select * from newtable;

Date
Categories
Tags
Comments

Published:January 21, 2010 View Post

MySQL

Leave a comment

how to delete duplicate rows in mysql

create table newtable asselect * from oldtable where 1 group by [specific column];

Date
Categories
Tags
Comments

Published:January 21, 2010 View Post

MySQL

Leave a comment

How to delete rows containing specific text string in a Mysql database

“delete from tablename where columnname like ‘%text to match%';  Make sure you know the text is contained in only the rows you want to delete otherwise MySQL may delete other database rows you didn’t want deleted

Date
Categories
Tags
Comments

Published:January 21, 2010 View Post

Uncategorized

Leave a comment