CodingMySQL - Help :(

  

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 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