i am implementing the realtime order tracking in my ecommerce website.I have a table called order. Order table contains following columns
Orders Table: id user_id seller_id tracking_id totalPrice
whenever a user place an order system generates an unique tracking id and that tracking id is stored in orders table.Now for realtime tracking i build an app that gives me the lat and long of the mobile phone location.I am getting that lat and long and showing map in my site dynamically.but i need to associate that tracking_id with that particular location.So how should i do please give me suggestion for that.
Note: User will enter the tracking id and system will give his order location in realtime.....