Cris D., on Oct 25 2007, 05:23 PM, said:
I'll have a into it over the weekend.
No rush, it's just a suggestion for improvement :)
Posted 25 October 2007 - 08:27 PM
Posted 26 October 2007 - 10:57 PM
Posted 18 January 2010 - 05:44 PM
This post has been edited by Ralph: 19 January 2010 - 02:16 PM
Reason for edit: Moved topic/post to proper location.
Posted 22 January 2010 - 10:37 AM
Wiper2007, on 18 January 2010 - 05:44 PM, said:
$tableName ="etobasket";//set this to the same tablename as in your snippet
$etoPrefix="etomite";//set this to the etomite installation prefix
$sql = 'CREATE TABLE `'.$etoPrefix.$tableName.'` ('
. ' `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, '
. ' `item` VARCHAR(100) NULL, '
. ' `description` VARCHAR(500) NULL, '
. ' `price` VARCHAR(10) NULL, '
. ' `pic_folder` VARCHAR(50) NULL, '
. ' `filename` VARCHAR(20) NULL, '
. ' `onPage` INT( 10 ) NULL, '
. ' `active` ENUM(\'1\',\'0\') NOT NULL DEFAULT \'1\''
. ' )'
. ' ENGINE = myisam;';
$created = $etomite->dbQuery($sql);
if($created){
return "Table created. Please remove this snippet and run etoBasket snippet.";
}else{
return "There is a server configuration error, please check your server permissions";
}This post has been edited by Cris D.: 22 January 2010 - 09:17 PM