Global Link Technologies

Adding Facebook Icon to Zen Cart

admin — Fri, 04 Feb 2011 17:13:56 +0000

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
*
*/

admin — Tue, 09 Feb 2010 00:08:28 +0000

alter table tablename add column id int auto_increment primary key;

admin — Mon, 08 Feb 2010 21:57:06 +0000

php string function

ucwords();

admin — Mon, 08 Feb 2010 21:40:10 +0000

php function ucfirst();

admin — Mon, 25 Jan 2010 20:16:52 +0000

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

admin — Sun, 24 Jan 2010 22:15:41 +0000

update cityfn set city = LOWER(city);

admin — Sun, 24 Jan 2010 17:39:41 +0000

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, ‘*’, ”);

admin — Thu, 21 Jan 2010 22:19:02 +0000

insert into oldtable select * from newtable;

admin — Thu, 21 Jan 2010 22:09:54 +0000

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

admin — Thu, 21 Jan 2010 21:54:32 +0000

“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