Page 1 of 1

PHP mySQL NEED HELP!

Posted: Sat Feb 28, 2009 9:04 pm
by gtops1
Hello Everybody

Im new to mySQL and am having a bit of trouble trying to find the right sql select statement. My table contains username and clubsocs. clubsocs contains a set of numbers which correspond to check box options checked by the user:


username clubsocs

John Smith 13, 64, 27, 48

Mary Smith 11, 23, 56, 16


Just wondering if it is possible to select username and one of the corresponding clubsocs numbers as required so say select John Smith and option 3..which would pick John Smith and 27...

If anyone has any ideas on how to do this or knows if this is even possible id be very thankful..