We need to create an single custom mysql query, to sort fields like this in an list:
(I'm using CB for Joomla, but in this case its an regular standart MYSQL query, this is an dummy example, i will provide the correct tables names and other info necessary to complete work)
All data its in same table...
1 - Show first user that status = single and sort it by User ID number
2 - After show users from item 1, show users that interest = soccer ,sorted by user ID again
3 - After show users from item 2, show users that social_netword = facebook, sorted again by User ID
I can do it in the least rate and in less than an hour.
I have 10 years of experience in MySQL database development. I can help you with other MySQL stuff as well, if required. Money is not the reason I am interested in this, I need good rating.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
15 freelancers are bidding on average $19 USD for this job
Well, not sure where catch is :-) but this is something like:
Select UserID, 1, Other info From Users Where status = single
UNION
Select UserID,2, Other info From Users Where Status <> single and interest = soccer
UNION
Select UserID, 3, Other info From Users Where Status <> single and interest <> soccer and netword = facebook
Order by 1, 2
Hi
I'm priyan from Sri Lanka. We are 5 friends group working on freelancer with technical knowledge.
We can do your job .
We have done many projects those can be seen on our profile with great reviews.
We lookingfoward to work for you.
Thanks
Hi
I have 3+ experience in web development.
I did many job like this.
I have strong knowledge of Mysql, Oracle, Database Design and I have also strong knowledge in languages like Java, JSP, PHP, Bootstrap CSS, Ajgular JS, HTML, CSS, JQuery etc .
Hello,
I am a systems analyst with 16 years of experience. I have designed many complicated SQL queries involving dozens of tables and strange sorting requirements.
Thank you for considering me and have a great day!
Hi,
I am expert in Web Development. I have more than 6 years of working experience in Web Development.
I have good knowledge about the following skills:
- PHP
- MySQL
- HTML
- CSS
- Javascript
- JQuery
You are warm welcome to contact me to discuss for further project details.
With Thanks and Regards
Prafulo
Hi I am a PHP Programmer. I can write for you the query! I really interested with this job. I can accept this job with a lowest wage among other applicants. As I want to earn some pocket money for my coming trip! I would really appreciate if you could hire me! Thank you so much!