Help!
Befor when using text are on of input fields our code was working fine but after changing some of the fields to dropdown boxes and radio button, the code does not continue to proceed to the command after the insert query.
Please help! I will attach the code for my add.php
New Record
NEW RECORD
|
Lead Section:
|
Backend
NMS
|
|
Activity Owner:
|
Core Network Planning and Engineering
NetIT SysAd
Svcs Design
IPBB Planning
Access Network Engineering
IT OSS
IT Mediation
|
|
System:
|
|
|
Activity:
|
|
|
Nature of Activity:
|
</td>
</tr>
<tr>
<td>
Update Time (yyyy-mm-dd)(hh:mm:ss):
</td>
<td>
<textarea name=uupdate_time rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Last Update:
</td>
<td>
<textarea name=ulast_update rows=15 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Coordinated with:
</td>
<td>
<textarea name=ucwith rows=2 cols=45 ></textarea>
</td>
</tr>
<tr>
<td>
Activity Reference:
</td>
<td>
<textarea name=uact_ref rows=2 cols=45></textarea>
</td>
</tr>
<tr>
<td>
Remarks:
</td>
<td>
<textarea name=uremarks rows=10 cols=45></textarea>
</td>
</tr>
|
<?php
include('connection.php');
if(isset($_POST['submit'])){
$ulead_sec = mysql_real_escape_string(trim($_POST['ulead_sec']));
if(!empty($ulead_sec)){
$AddQuery = "INSERT INTO tasklist (lead_sec, act_own, system, activity, nature_act, update_time, last_update, cwith, act_ref, remarks)
VALUES ('$_POST[ulead_sec]','$_POST[uact_own]','$_POST[usystem]','$_POST[uactivity]','$_POST[unature_act]','$_POST[uupdate_time]','$_POST[ulast_update]','$_POST[ucwith]','$_POST[uact_ref]','$_POST[uremarks]')";
mysql_query($AddQuery);
echo "
SUCCESSFULLY ADDED!
";
echo "
";
echo '
BACK';
}
else{
header("Location:view.php");
}
}
?>
