Hot to get empty field in column, and get column name?
Posted: Wed May 15, 2002 8:36 pm
Hi.
This is a mix of PHP and MySQL question, so excuse me...
Having a table with the following configuration:
groupID, user1, user2, user3, ... untill user10
Each time a user registers (different table), i want to put him in a group (any group), wich has an empty spot (any spot)...
But i can't manage to do that... the main problem is that i can't get the column name of the first result i get looking for an empty field.
Any help?
Thanks in advance (yep, i'm new at both PHP and SQL)

This is a mix of PHP and MySQL question, so excuse me...
Having a table with the following configuration:
groupID, user1, user2, user3, ... untill user10
Each time a user registers (different table), i want to put him in a group (any group), wich has an empty spot (any spot)...
But i can't manage to do that... the main problem is that i can't get the column name of the first result i get looking for an empty field.
Any help?
Thanks in advance (yep, i'm new at both PHP and SQL)