CodingMySQL - Help :(

  

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  Peter (BOUGHTONP)   16 Sep 2006 19:07 
 To:  steve       4 of 9 
30653.4 In reply to 30653.3 
Hmmm, dunno if PHP allows composite queries - have you tried running them individually, one after the other?

Or even directly in a MySQL terminal to check the code is okay...

0/0
 Reply   Quote More 

 From:  steve    16 Sep 2006 19:19 
 To:  Peter (BOUGHTONP)      5 of 9 
30653.5 In reply to 30653.4 
I THINK I DID IT XD

The sum(blah,blah,blah) as total wasn't valid - I bodged it to;

(sum(blah)+sum(blah)+sum(blah)) as total

And yay :D

0/0
 Reply   Quote More 

 From:  steve    16 Sep 2006 19:36 
 To:  Peter (BOUGHTONP)      6 of 9 
30653.6 In reply to 30653.4 
omg DOUBLE HELP PETER :C

Thankyou very much as I have made it work :D

BUT! How do I make it so it only reports one of each ID?

It's turning up some IDs several times in each :'S

0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)   16 Sep 2006 20:33 
 To:  steve       7 of 9 
30653.7 In reply to 30653.6 
Yay. :D


Just change it to SELECT DISTINCT ... and it should return only one per person.

0/0
 Reply   Quote More 

 From:  steve    16 Sep 2006 20:36 
 To:  Peter (BOUGHTONP)      8 of 9 
30653.8 In reply to 30653.7 
Yay :D



Hooray XD!

0/0
 Reply   Quote More 

Message 30653.9 was deleted

Reply to All    
 

1–9

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats