Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Home

krisdmd

New Members

View Profile See their activity

Posts
2
Joined
May 28, 2013
Last visited
May 30, 2013

krisdmd's Achievements

Newbie

Newbie (1/5)

0

Reputation

Mysql query problem

krisdmd replied to krisdmd's topic in MySQL Help

well i need some kind of sort by property='rating' and the value of this rating DESC I cannot change the structure of the table because it's from a partner site
- May 28, 2013
- 5 replies
- - sql
  - order by
  - (and 2 more)
    Tagged with:
    
    sql
    
    order by
    
    query
    
    mysql
Mysql query problem

krisdmd posted a topic in MySQL Help

Hello, I have a table called profiles. I have 3 colums, id,property,value The property has the items name,rating,birthday and the column value holds the value of each property. Now i want to order my results by the property rating and value Desc. I'm stuck here how i can do this ? Can anyone helps me with that ?
- May 28, 2013
- 5 replies
- - sql
  - order by
  - (and 2 more)
    Tagged with:
    
    sql
    
    order by
    
    query
    
    mysql

×

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

×

Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.