Print Page - Data from sql table into orders/details

Title: Data from sql table into orders/details
Post by: lol2x on July 04, 2013, 22:57:06 PM

I am trying to add tracking number service into my VM shop. I made tracking_number column into SQL table virtuemart_products, now on orders/details page i want to show (using the API) route of that shipping. I dont know php very well so i can't do that alone, i have something like that:

Code Select

	$params = array(
		'mode'		=> 'package',
		'courier' 	=> 'DHL', 
		'package' 	=> 'HERE I NEED TO WRITE PACKAGE NUMBER FROM MYSQL', 
		'output' 	=> 'xml', 
		'detailed' 	=> true,
	);

I have no idea how can i put the value from mySql into that array() Anybody can help?

Title: Re: Data from sql table into orders/details
Post by: lol2x on July 06, 2013, 17:28:59 PM

Title: Re: Data from sql table into orders/details
Post by: Milbo on July 09, 2013, 10:37:37 AM

For the product? you sell unique products? I doubt it.

You must use the plugin table for that and learn how to use the plugin tables.

Title: Re: Data from sql table into orders/details
Post by: lol2x on July 10, 2013, 20:06:46 PM

virtuemart_orders, my mistake sorry :/

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Development & Testing => Topic started by: lol2x on July 04, 2013, 22:57:06 PM