How can I insert tracking number into ps_orders in automatic?

[ietax]

Hi, i nedd to insert tracking number on ps_orders (delivery_number)..

 

I generate tracking number by php

 

Using mysql, how can I REPLACE or INSERT to...???

 

I have difficulty to set mysql command...

 

range_trk is my variable (track numb)

 

"REPLACE INTO ps_orders (delivery_number) VALUES ('$range_trk')";

 

Thanks

Edited November 13, 2013 by ietax (see edit history)

[vekia]

hello

you want to insert the same tracking number for all orders or only for certain of them?

[ietax]

Ho, i want each orders different training number, i can generate track numb by php... But i cannot insert it in ps_table...

[vekia]

so you're saying that this identification number must be different for each order? and you want to generate it randomly?

and when? right after order? or ... ?

[ietax]

I generate teacking number by php, export all orders details in txt file and (by php) i can generate teacking number. At the end i'dlike to insert track numb on ps-table