PHP mySQL NEED HELP!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gtops1
Forum Newbie
Posts: 1
Joined: Sat Feb 28, 2009 9:02 pm

PHP mySQL NEED HELP!

Post 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..
Post Reply