How to display the premium users product in top in search engine?

Question

2.33/5 (2 votes)

See more:

HI ALL,
I have made a website in which user can upload their advertisement.I have added search form in which everyone can search products from my website.But i want to display my paid user data in top whenever any person use search form of my website.I am working on it.I need your suggestion and help.Please help me.
Thanks all,

Posted 6-Dec-13 7:24am

dps2305

Add a Solution

Comments

Vishal Pand3y 6-Dec-13 13:28pm

can you Provide some more information whether you want your paid user's advertisement First ? or what
and Most Importantly what have you tried

[no name] 6-Dec-13 13:50pm

Yes,I want to display the data of my paid user advertisement first.

Sergey Alexandrovich Kryukov 6-Dec-13 14:00pm

And?..
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-06T08:35:00

So, you either do two searches: one through Premium ads, and one through non-premium ads and display them in that order, or you do one search but add a "order by" criteria which puts premium ones first.

We can't be specific as we have no idea how you are storing, accessing or displaying any of your information!
But, if it's SQL, then something along the lines of:

SQL

SELECT * FROM MyAds WHERE searchText LIKE '%I want this%' ORDER BY premiumRate, searchText

should help.