I have a ranking page that show the first 50 players using a query
-> SELECT TOP 50 * FROM Character WHERE Name != '' AND AID NOT IN(SELECT AID FROM Account WHERE UGradeID = 253) ORDER by RebirthLevel DESC, XP DESC
I actually want to add a Search Script on this page where you can search your Character name and it will give your ranking but I want this to show your ranking + giving the players after you.
Except if you search for that character named: Nicolas, it will give your ranking and 49 players after your ranking.
Hello sir,
how do you do?
I saw your description very carefully and then i think your job is very suitable for me.I have experienced of developing web site for 7 [login to view URL] I have strongest skill php and jquery plugin and several framework using MVC( Zend,Smarty,CodeIgniter and CakePHP).
I have made web sites for frontend -Backend.I am believing i will make good relationship with [login to view URL] will be known my good skill and ability via our job.I am full time developer and i can work in your TimeZone.I am ready for you and I will wait for your good message.
$25 USD en 2 días
4,9 (10 comentarios)
3,3
3,3
13 freelancers están ofertando un promedio de $27 USD por este trabajo
Your first query may be written by LIMIT very easily, you don't need even to use the inner query there.
Now you need to add one search function where user will search by charater name. And it should fetch that user record + 49 next ranking user records. It is easy. We can do that in few hours.
Hi Employer,
I have read your description and been interested in your project.
Let me help you add the Search Script that search the character name and 49 other character have ranking after him.
I'm ready to discuss and start to work on it now.
HI - I have 8+ years experience in PHP, PHP, CakePHP Open-source, DotNet, Flex3.0 / FlashBuilder, JQuery, BootStrap, Javascript and CSS, I am very much interested, Can we discuss further?
Thanks,
Deep
Hello,
I have good knowledge of PHP and databases gained through my technical education and extracurricular projects. I don't have much experience here, but I commit to deliver very good results. I can help you with this project, but I would need some clarifications about it. The search is only made in those 50 players, or in all of them? Is there a design to be used for displaying? For a player, only display the ranking and that is it, without the players before or after?
Regards,
Tudor
Hi , I have 15 years experience working with SQL,
I am new freelancer and i will provide you the SQL with very low price.
Also i will offer you 2 hours free help.
Currently I am working at big financial organization in which I’am responsible for the MIS. I have designed and Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2.
The database is being administrated by me and is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL and the size is apox. 4TB,
A numerous of reports are being produced via .aspx pages and SSRS.