The list of sites that can be accessed contains the following information:
The site prefix - 3 letters
The site name - Full Name
The site admin power - a single digit from 1-3
I'd like the information to be inserted into my MySQL db when this form is submitted. At the moment, when I submit the data it only enters ONE of the sites (no matter how many are checked), and it refuses to enter any site (whether checked or not) unless that site is "RoN".
To see an example, head here:
http://www.empiregaming.net/xg/news/edituser.php
My current SQL statement:
Code: Select all
$sql = "insert into ".$username."_sites ( site_name, site_pre, site_value ) values ( '$site_name', '$site_pre', '$site_value')";
$query = mysql_query($sql);