Posted 1 year ago
hi
i didnt realise it would be difficult for you guys to figure out, heres an example;
$result = mysql_query("SELECT * FROM ".$wpdb->prefix."orderdata WHERE ".$wpdb->prefix."orderdata.order_id='".strip_tags($GLOBALS['PPTorderID'])."'", $wpdb->dbh)
or die(mysql_error().' on line: '.__LINE__);
$array = mysql_fetch_assoc($result);
the value $array then stores all of the order data thats saved in the database;
autoid MEDIUMINT( 10 ) NOT NULL AUTO_INCREMENT ,
cus_id VARCHAR( 10 ) NOT NULL ,
order_id VARCHAR( 50 ) NOT NULL ,
order_ip VARCHAR( 100 ) NOT NULL ,
order_date DATE NOT NULL ,
order_time TIME NOT NULL ,
order_data LONGTEXT NOT NULL ,
order_items VARCHAR( 255 ) NOT NULL ,
order_address BLOB NOT NULL ,
order_addressShip BLOB NOT NULL ,
order_country VARCHAR( 150 ) NOT NULL ,
order_email VARCHAR( 255 ) NOT NULL ,
order_total VARCHAR( 10 ) NOT NULL ,
order_subtotal VARCHAR( 10 ) NOT NULL ,
order_tax VARCHAR( 10 ) NOT NULL ,
order_coupon VARCHAR( 10 ) NOT NULL ,
order_couponcode VARCHAR( 100 ) NOT NULL ,
order_currencycode VARCHAR( 10 ) NOT NULL ,
order_shipping VARCHAR( 10 ) NOT NULL ,
order_status INT( 1 ) NOT NULL DEFAULT '0',
cus_name VARCHAR( 100 ) NOT NULL ,
payment_data BLOB NOT NULL ,