work is with php and mysql.
I need queries and php code to run them.
Also i have few questions about sql tables i want to ask during project.
i want person who communicate well and can suggest his offers if he see it can be done better or easier then i described.
it should be written easy and simple.
This is small project i am hopping small bids.
So i have 3 tables in database:
table name ( columns in table)
accesspoints (wifimac ,signals, lat, lon)
usersdata (PhoneIMEI, wifimac, signals, lat, lon, timestamp)
locations (PhoneIMEI, wifimac, signals, lat, lon, timestamp)
accesspoints and locations tables are where data will be stored from queries.
usersdata is table where data is comming from system users.
insert data to locations table by using data from usersdata and accesspoints tables.
3.1 there can be multiple rows with same PhoneIMEI but different others columns values in usersdata.
3.2 first i need to take wifimac from usersdata table and check if there is same wifimac in accesspoints then from those who match choose only one with highest signal.
3.3 this should be done for every PhoneIMEI
3.4 this should be done from latest data from timestamp for every PhoneIMEI (time from timestamp should be taken in minutes not seconds)
3.5 then data should be sent to locations table (usersdata.PhoneIMEI, accesspoints.wifimac, usersdata.signals, accesspoints.lat, accesspoints.lon)
I need php fields where you can insert wifimac address and select time interval. and it shows results on screen from query2.
4.1 i need to count how many different PhoneIMEI from usersdata table had wifimac that was inserted during selected time interval.