New Topic/Question
This topic is locked
Posted 02 August 2002 - 07:01 AM
When selecting the top rated option in the resources section, I noticed it returns a list which seems to be sorted by date submited, no it's rating.
What's up?
4 Replies - 955 Views - Last Post: 03 August 2002 - 11:26 AM
MultiQuoteReplies To: Top Rated Resources
#2
skyhawk133
- Head DIC Head
-
Reputation: 1981
- Posts: 20,434
- Joined: 17-March 01
Re: Top Rated Resources
Posted 02 August 2002 - 09:28 PM
what's up is I have to do a little more work on the script... I need to pull back from the database all records and order by $total_rating/$votes
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
Was This Post Helpful?
0
#3
fyrestorm
- D.I.C Lover
-
Reputation: 10
- Posts: 3,113
- Joined: 04-April 02
Re: Top Rated Resources
Posted 03 August 2002 - 09:42 AM
skyhawk133, on Aug 2 2002, 10:28 PM, said:
what's up is I have to do a little more work on the script... I need to pull back from the database all records and order by $total_rating/$votes
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
that's why you would make a variable named $orderby and set it equal to $total_rating/$votes, and then sort by that...
Was This Post Helpful?
0
#4
supersloth
- serial frotteur - RUDEST MEMBER ON D.I.C.
-
Reputation: 4695
- Posts: 28,516
- Joined: 21-March 01
Re: Top Rated Resources
Posted 03 August 2002 - 11:08 AM
fyrestorm, on Aug 3 2002, 10:42 AM, said:
skyhawk133, on Aug 2 2002, 10:28 PM, said:
what's up is I have to do a little more work on the script... I need to pull back from the database all records and order by $total_rating/$votes
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
that's why you would make a variable named $orderby and set it equal to $total_rating/$votes, and then sort by that...
EXACTLY what i told him when i was at his house and he was coding it.
Was This Post Helpful?
0
#5
fyrestorm
- D.I.C Lover
-
Reputation: 10
- Posts: 3,113
- Joined: 04-April 02
Re: Top Rated Resources
Posted 03 August 2002 - 11:26 AM
supersloth, on Aug 3 2002, 12:08 PM, said:
fyrestorm, on Aug 3 2002, 10:42 AM, said:
skyhawk133, on Aug 2 2002, 10:28 PM, said:
what's up is I have to do a little more work on the script... I need to pull back from the database all records and order by $total_rating/$votes
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
but I'm not sure if I can do math functions IN the sql statement... right now I have it like that and it's not working.
that's why you would make a variable named $orderby and set it equal to $total_rating/$votes, and then sort by that...
EXACTLY what i told him when i was at his house and he was coding it.
you of all people should know by now that he doesn't listen to what people say when he's coding until it doesn't work...
Was This Post Helpful?
0
Page 1 of 1
| 