need php function to show report from 3 tables for clicked operator WHERE operator_id=$_REQUEST['operator_id'] the report should show a table says
tour name (list of all tours the operator earned points at it)
tour points (sum of all points the operator collect for each tour)
tour position (the higher points operator collect for each tour example. selected operator collected 500 points at tour name Boat trip, but other operators collected less that makes the selected operator position for this tour 1 and other operator will less points number 2 and so .. )
after that would like to have a summary says you have 2 tours at position one (66% of your total tours) and 1 tour at position two (33% of your total tours)
here is my database tables table1 operators [ operator_id , Operator_name, ] records [ 1 Best Tours , 2 Magi Tours, 3 Fun Tours ]
table2 tours [tour_id, tour_name] records [ 1 Safari Tour, 2 Boat trip, 3 Cairo over night, ]
table3 tour_points [tour_point_id, points_amount, operrator_id, tour_id] records [ 1, 100, 1, 1 2, 50, 1, 1 3, 50, 1, 1 4, 50, 1, 2 5, 50, 2, 2 6, 1000, 2, 1 ]
Hello!
With 99% completion rate, 720 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
Hello Sir, I have experience on changing or adding something to already existing script as I have a good knowledge of the program, you can test me though, thanks.