Hi! I'm having some problems with checkboxes at the moment, and i'd be glad if you 
could help me solve it... i'll give a brief explanation of the situation first so that 
you can understand what i'm talking about :-)

  I have the tables 'User' (containing userid,etc), 'Category' (containing 
category_id) and the table User_Category (user)id and category_id) since i have a 
many-to-many relationship between user and category

  Now, when i add a new user, i display a list of the category names, with a checkbox 
next to each, so that the user can check more than 1 category

  Now, the problem: let's say i want to modify a particular user.... i thus have a 
link on the user, e.g.

<a href="modify.php?id='.$row["user_id"].'">'.$row["name"].'</a>

  Now, on modify.php, i want to display all the values that the user posted initially 
(lastname, firstname, username, password, etc...)
Here i also want to display all the category names with a checkbox next to each (this 
is easy!)

$sql = "SELECT * FROM category";
$result = mysql_query($sql);

// (this is referenced as LOOP1 below)
while ($row = mysql_fetch_array($result))
 echo $row["name"];
 echo '<input type="checkbox" name="cat[]" value='.$row["category_id"].'>';

 Now, to get the values of category_id that the user previously selected, i just need 
to do 

$qry = "SELECT category_id FROM user_category WHERE user_id='$id'";
$result2 = mysql_query($qry);

// for example, i have 8 records in my table category, therefore i'll have 8 
checkboxes with id values 1, 2...8
// now assume that, when filling his form, the user clicked the checkboxes with id 
values 1, 2, 3, 4, 5 only

NOW ==>>> THE PROBLEM: (finally we reach there!!!) :-)

HOW do i modify LOOP1 so that i loop the second query $qry to validate which value of 
category_id in each checkbox corresponds to the values returned by my query $qry, and 
i check ONLY THOSE checkboxes, and leave the other checkboxes as unchecked?

I'd be grateful if you could help
Thanks and regards,

Reply via email to