|
|
www.scoreattack.net
Started by Lance Way at 03-04-2006 12:44 AM. Topic has 21 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-04-2006, 12:44 AM
|
Lance Way
Joined on 02-11-2006
England
Posts 148
|
Re: Database creation advice request.
|
|
|
|
|
It's all looking fairly fine now, though I should say that the new PHP pages are always loaded "but with errors on page" according to IE status bar. (according to the "details" tab, it's syntax errors).
|
|
|
|
|
Report
|
|
|
|
|
03-04-2006, 3:33 AM
|
EVL
 
Joined on 01-30-2006
UK
Posts 83
|
Re: Database creation advice request.
|
|
|
|
|
|
Yeah, your image rollovers are somewhat broken.
I've just had a little look for rollover scripts on the web, and this
looks good: http://www.dnolan.com/code/js/rollover/ though you'd have
to rename all of the rollover images.
There will be plenty of other scripts for rollovers on the web, but make sure you look for cross browser or compliant ones. :)
edit: Oh, it's looking really good though! (I can't just come out with negativity) :)
|
|
|
|
|
Report
|
|
|
|
|
03-04-2006, 9:37 AM
|
tabitha
Joined on 01-22-2006
Posts 536
|
Re: Database creation advice request.
|
|
|
|
|
|
I will have a look at the rollovers at some point next week. I think it
might be something to do with PHP going absolutely nuts when you have
inverted commas or something in it. Anyway, the main thing is its
working and seirously EVL I cant thank you enough.
|
|
|
|
|
Report
|
|
|
|
|
03-06-2006, 4:28 AM
|
EVL
Joined on 01-30-2006
UK
Posts 83
|
Re: Database creation advice request.
|
|
|
|
|
|
No worries tabitha, I'm glad to be able to help.
By the way, I noticed that skaternights' scores have dissappeared in the update!
|
|
|
|
|
Report
|
|
|
|
|
03-06-2006, 8:06 AM
|
tabitha
Joined on 01-22-2006
Posts 536
|
Re: Database creation advice request.
|
|
|
|
|
|
Thanks for pointing that out. I will get on it in a second.
Dont suppose you have any idea how to sort this problem out?
This is the final page I am having trouble with, its going to be totals
for everyones scores for bosses/dreams/mares to give an overall picture
of how people are doing.
http://www.scoreattack.net/scorestats.php
I have the code here,
http://www.scoreattack.net/scorestats.txt
I need to find a way to sort the value $btotal in reverse numeric order. Any ideas would be MUCH appreciated.
|
|
|
|
|
Report
|
|
|
|
|
03-06-2006, 8:35 AM
|
EVL
Joined on 01-30-2006
UK
Posts 83
|
Re: Database creation advice request.
|
|
|
|
|
|
The best way to do that would be to order it in the sql, something like
select gul + puf + cla + rea + jac + gul + wiz as total from tbl order by gul + puf + cla + rea + jac + gul + wiz desc
or possibly (can't quite remember, but I think both should work)
select gul + puf + cla + rea + jac + gul + wiz as total from tbl order by total desc
then just do $btotal = $r["total"]
|
|
|
|
|
Report
|
|
|
|
|
03-06-2006, 6:13 PM
|
tabitha
Joined on 01-22-2006
Posts 536
|
Re: Database creation advice request.
|
|
|
|
|
|
I didnt know you could use the plus symbol in mySQL I htought it had to
be the sum command which I tried but had Zero luck with. I will give
this a go in a second.
- edit -
Looks like it is working! Thanks VERY much for the help.
|
|
|
|
|
Report
|
|
|
|
|
|
Page 2 of 2 (22 items)
|
< 1 2 |
|
|
|
Scoreattack.net » Score Attack - ... » www.scoreattack... » Re: Database creation advice request.
|
|
|
|