teknojunkey Posted March 1, 2004 Posted March 1, 2004 hi everyone is it posible to remove items within the db by sql query? i really want to format the whole field. i have 3 orders in the db that i cannot access (they are just test orders) i canot delete them through admin. something like this? DROP TABLE IF EXISTS orders; also i am in the final stages of development and have only one more problem on this page i have results appearing with prices and pictures. http://pfaflare.com/oscommerce-2.2ms2/cata...x.php?cPath=1_2 i want the page to look like this one, http://pfaflare.com/oscommerce-2.2ms2/cata...php?cPath=1_2_4 or without the results at all, only the categories choices. thanks ewen
teknojunkey Posted March 1, 2004 Author Posted March 1, 2004 ok it wasnt so hard, seems to be the same with all my osc problems. DROP TABLE IF EXISTS orders; CREATE TABLE orders ( orders_id int NOT NULL auto_increment, customers_id int NOT NULL, customers_name varchar(64) NOT NULL, customers_company varchar(32), customers_street_address varchar(64) NOT NULL, customers_suburb varchar(32), customers_city varchar(32) NOT NULL, customers_postcode varchar(10) NOT NULL, customers_state varchar(32), customers_country varchar(32) NOT NULL, customers_telephone varchar(32) NOT NULL, customers_email_address varchar(96) NOT NULL, customers_address_format_id int(5) NOT NULL, delivery_name varchar(64) NOT NULL, delivery_company varchar(32), delivery_street_address varchar(64) NOT NULL, delivery_suburb varchar(32), delivery_city varchar(32) NOT NULL, delivery_postcode varchar(10) NOT NULL, delivery_state varchar(32), delivery_country varchar(32) NOT NULL, delivery_address_format_id int(5) NOT NULL, billing_name varchar(64) NOT NULL, billing_company varchar(32), billing_street_address varchar(64) NOT NULL, billing_suburb varchar(32), billing_city varchar(32) NOT NULL, billing_postcode varchar(10) NOT NULL, billing_state varchar(32), billing_country varchar(32) NOT NULL, billing_address_format_id int(5) NOT NULL, payment_method varchar(32) NOT NULL, cc_type varchar(20), cc_owner varchar(64), cc_number varchar(32), cc_expires varchar(4), last_modified datetime, date_purchased datetime, orders_status int(5) NOT NULL, orders_date_finished datetime, currency char(3), currency_value decimal(14,6), PRIMARY KEY (orders_id) also the results thing was in the admin pages under maximum values!
wizardsandwars Posted March 1, 2004 Posted March 1, 2004 Probably should have just trucated the table. TRUNCATE TABLE orders ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.