Just delete whatever's there and add your statement ('ALTER TABLE...) I think the other stuff is there to help you create an SQL statement, but not for what you're trying to do.
Type: Posts; User: k4satin
Just delete whatever's there and add your statement ('ALTER TABLE...) I think the other stuff is there to help you create an SQL statement, but not for what you're trying to do.
I think what you'd want would go more like this:
ALTER TABLE `products` ADD `products_condition` INT NOT NULL , ADD `products_warranty` VARCHAR( 32 ) NOT NULL;
You might also want to edit INT...
Ajeh,
Glad to see you've joined us in this thread! We could use someone a little more knowledgeable.
Would I mess everything up if I asigned my sku numbers as my product id's instead of using...
I looked at what they did for the 'description' field (its in TABLE products_description) and they just put 'text' in the 'Type' field. Have you tried that?
As for the drop-downs, I'd suggest...
The line that crazy_chris wrote, "ALTER..." is the SQL query itself. The menu that you found is an alternative to writing your own SQL queries for us SQL-illiterate folks. When you fill out the...
Yeah! Only one day, and it works!!! (I had to focus on my live site for awhile, and just got back to working on this...)
It took me longer to uninstall the Additional Products Fields mod than it...
I'm not sure if I can help, but it worked for me. I got the exact same line of fields that you show here (starting with 'Field'...). I filled in the ones that crazy_chris mentioned & left the rest...
Thanks for the suggestion. That's what I was planning to do (or vice versa), now that I found this. (Unless someone has a better idea...) Does it matter which one is the new field and which uses...
Wow, I wish I'd seen this sooner. I've spent so much time reading 23 pages of piece-meal instructions on the Additional Products Fields contribution, only to find out that TheOracle is no longer...