1. Is it ok to use a drop down box with PHP? and are there any special things i need to do to post them to the database (MySQL)
2. I am getting this Error: Unknown column 'N' in 'field list' Ive Searched for the N Field in the database and the php Script with no avail.
Code: Select all
$sql = "INSERT INTO $table_name VALUES
('$_POST[firstname]', '$_POST[lastname]', $_POST[company], '$_POST[username]', password('$_POST[password]'), 'Users', '', '', '$pchange',
'$_POST[email]', $_POST[access], '$default_url', '$verify', '')";Code: Select all
<span style="font-size: 14px"><strong style="font-weight: 400"><font face="Tahoma">Type
of Access Requested: </font></strong></span><font face="Tahoma"><font size="2"><BR>
</font><font face="Tahoma" size="1">
<label>
<select name="access" >
<option>Patient</option>
<option>Referral</option>
<option>Employee</option>
<option selected>Please Select Access Type</option>
</select>
</label>
</font></font></p>Sorry if this is a repost i did a quick search