about checkbox.. how to checked (n) element by php code?

[web_designer_iq]

Hi,
I have a 2 MySQL table.

Table Number 1: (stored all countries) by the following fields:
1) country_id
2) country_name

Table Number 2: (stored user choices countries from table1) by the following fields:
1) user_id
2) user_countries

for example:
if you selected:
U.S.A
United Kingdom
Canada
Germany
etc...
I will store that's countries by this format: 1,2,3,4 etc... in user_countries field from table2.

My questions is:
I want to create a web page with checkbox elements and show all countries with checkbox element:
i.e:
[ ] Afghanistan
[ ] etc...
[ ] Zimbabwe.

How to checked checkbox element by user choices?

Thanks

[Clarkey_Boy]

Base your code on the following:

<?php
$conn = "connection line...";
if(isset($_POST["submit"])) {
[indent]for($getcountry = $conn->Execute("SELECT * FROM countries"); !$getcountry->EOF; $getcountry->MoveNext()) {[indent]$countryid = $getcountry->Fields("ID");
$countryname = $getcountry->Fields("name")->Value;
if($_POST["country".$countryid] == "on") {[indent]echo $countryname."<br>";[/indent]
}[/indent]
}[/indent]
}

echo "
[indent]<form method=post><table width=100%>
<tr><td width=75%>Country Name</td><td width=25%>Select Country</td></tr>";[/indent]
for($getcountry = $conn->Execute("SELECT * FROM countries"); !$getcountry->EOF; $getcountry->MoveNext()) {[indent]$countryid = $getcountry->Fields("ID");
$countryname = $getcountry->Fields("name")->Value;
echo "[indent]<tr><td width=75%>".$countryname."</td><td width=25%><input type=checkbox name='country".$countryid."'></td></tr>";[/indent][/indent]
}
echo "[indent]<tr><td width=75%></td><td width=25%><input type=submit name=submit></td></tr>
</table></form>";[/indent]
?>

Hope this is what you are looking for.

Clarkey Boy

[ahundiak]

Might be better off having your second table look like
user_id
country_id

With one record for each country associated with a user. Then you can use a simple query to get all the countries for a given user (or vice versa)