Here is the form that gets filled out to add a new Speaker to our Seminar database: [code] <html> <head> <title>Genetics Seminar - Add Speaker</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form action="speaker_insert.php" method="post" enctype="multipart/form-data" name="MForm"> <p align="center">Use this form to book a Seminar Speaker<br> If you need to start a new semester, <a href="newsemester.php">Click Here </a></p> <table width="95%" border="0" align="center" cellpadding="2" cellspacing="0"> <tr> <td colspan="4"> </td> </tr> <tr> <td width="25%">Speaker</td> <td width="1%"> </td> <td width="35%" valign="top"><input name="speaker" type="text" id="speaker" size="60"></td> <td width="34%" rowspan="6" align="center" valign="middle"><input type="submit" name="Submit" value="Submit"></td> </tr> <tr> <td>Speaker's Location </td> <td> </td> <td valign="top"><input name="location" type="text" id="location" size="60"></td> </tr> <tr> <td>Topic</td> <td> </td> <td valign="top"><input name="topic" type="text" id="topic" size="60"></td> </tr> <tr> <td>Host</td> <td> </td> <td valign="top"><input name="spkhost" type="text" id="spkhost" size="60"></td> </tr> <tr> <td>Time<font size="2"> </font></td> <td> </td> <td valign="top"><select name="spktime" id="select"> <option value="12:00am">12:00am</option> <option value="12:30am">12:30am</option> <option value="1:00am">1:00am</option> <option value="1:30am">1:30am</option> <option value="2:00am">2:00am</option> <option value="2:30am">2:30am</option> <option value="3:00am">3:00am</option> <option value="3:30am">3:30am</option> <option value="4:00am">4:00am</option> <option value="4:30am">4:30am</option> <option value="5:00am">5:00am</option> <option value="5:30am">5:30am</option> <option value="6:00am">6:00am</option> <option value="6:30am">6:30am</option> <option value="7:00am">7:00am</option> <option value="7:30am">7:30am</option> <option value="8:00am">8:00am</option> <option value="8:30am">8:30am</option> <option value="9:00am">9:00am</option> <option value="9:30am">9:30am</option> <option value="10:00am">10:00am</option> <option value="10:30am">10:30am</option> <option value="11:00am">11:00am</option> <option value="11:30am">11:30am</option> <option value="12:00pm" selected>12:00pm</option> <option value="12:30pm">12:30pm</option> <option value="1:00pm">1:00pm</option> <option value="1:30pm">1:30pm</option> <option value="2:00pm">2:00pm</option> <option value="2:30pm">2:30pm</option> <option value="3:00pm">3:00pm</option> <option value="3:30pm">3:30pm</option> <option value="4:00pm">4:00pm</option> <option value="4:30pm">4:30pm</option> <option value="5:00pm">5:00pm</option> <option value="5:30pm">5:30pm</option> <option value="6:00pm">6:00pm</option> <option value="6:30pm">6:30pm</option> <option value="7:00pm">7:00pm</option> <option value="7:30pm">7:30pm</option> <option value="8:00pm">8:00pm</option> <option value="8:30pm">8:30pm</option> <option value="9:00pm">9:00pm</option> <option value="9:30pm">9:30pm</option> <option value="10:00pm">10:00pm</option> <option value="10:30pm">10:30pm</option> <option value="11:00pm">11:00pm</option> <option value="11:30pm">11:30pm</option> </select></td> </tr> <tr> <td>Location of Seminar <font size="2"> </font></td> <td> </td> <td valign="top"><input name="where" type="text" id="where" value="Department of Genetics Library - McDonnell Science Building" size="60"></td> </tr> <tr> <td>Speaker's Photo</td> <td><br></td> <td><input type=file name="userfile"></td> <td> </td> <td> </td> </tr> <tr> <td colspan="4"> </td> </tr> </table> <?PHP include "../conf/conf.php"; $data=mysql_query("select * from reserve") or die($SELECT_ERROR); ?> <TABLE ALIGN="CENTER" BORDER="1" BORDERCOLOR="#990000"> <TR> <TD align="center"><B>ID<br>EDIT</B></TD> <TD align="center"><B>Date</B></TD> <TD align="center"><B>Speaker</B></TD> <TD align="center"><B>Topic</B></TD> <TD align="center"><B>Host</B></TD> </TR> <?PHP $i=1; while ($break_data=mysql_fetch_array($data)) { if ($i % 2) { $color = $tbl_oncolor; } } else { $color = $tbl_offbgcolor; } $uid=$break_data['uid']; $dbdate=$break_data['dbdate']; $speaker=$break_data['speaker']; $location=$break_data['location']; $topic=$break_data['topic']; $spkhost=$break_data['spkhost']; print "<TR>"; print "<TD BGCOLOR=$color>$uid <input name=\"choose\" type=\"radio\" value=\"$uid\"> </TD>"; print "<TD BGCOLOR=$color>$dbdate</TD>"; print "<TD BGCOLOR=$color >$speaker - $location</TD>"; print "<TD BGCOLOR=$color>$topic</TD>"; print "<TD BGCOLOR=$color>$spkhost</TD>"; print "</TR>"; $i++; } ?> </TABLE> </form> </body> </html> [/code] Here is the script the form gets sent to: [code] <?php include "../conf/conf.php"; import_request_variables("gP", "rvar_"); mysql_query("UPDATE reserve SET speaker='$rvar_speaker', location='$rvar_location', topic='$rvar_topic', spkhost='$rvar_spkhost', spktime='$rvar_spktime', whereheld='$rvar_where' WHERE uid='$rvar_choose'"); $data=mysql_query("select * from reserve where uid='$rvar_choose'") or die($SELECT_ERROR); ?> <style type="text/css"> <!-- .style1 { font-family: Arial, Helvetica, sans-serif; font-weight: bold; } --> </style> <P><center class="style1">Here is the entry you Added/Changed <BR>Please click <a href="newspeaker.php">Here</a> to return to the Add/Change page</center> </P> <TABLE ALIGN="CENTER" BORDER="1" BORDERCOLOR="#990000"> <TR> <TD align="center"><B>ID</B></TD> <TD align="center"><B>Date</B></TD> <TD align="center"><B>Speaker</B></TD> <TD align="center"><B>Topic</B></TD> <TD align="center"><B>Host</B></TD> </TR> <?PHP $i=1; while ($break_data=mysql_fetch_array($data)) { if ($i % 2) { $color = $tbl_oncolor; } else { $color = $tbl_offbgcolor; } $uid=$break_data['uid']; $dbdate=$break_data['dbdate']; $speaker=$break_data['speaker']; $location=$break_data['location']; $topic=$break_data['topic']; $spkhost=$break_data['spkhost']; print "<TR>"; print "<TD BGCOLOR=$color>$uid</TD>"; print "<TD BGCOLOR=$color>$dbdate</TD>"; print "<TD BGCOLOR=$color >$speaker - $location</TD>"; print "<TD BGCOLOR=$color>$topic</TD>"; print "<TD BGCOLOR=$color>$spkhost</TD>"; print "</TR>"; $i++; } if(!empty($_FILES["userfile"])) { $uploaddir = "/home/www/fisher/docs/seminarphp/admin/photos/"; // set this to wherever //copy the file to some permanent location if (move_uploaded_file($_FILES["userfile"]["tmp_name"], $uploaddir . $_FILES["userfile"]["name"])) { echo("file uploaded"); } else { echo ("error!"); } } $picturename = $_FILES["userfile"]["name"]; mysql_query("UPDATE reserve SET picture='http://www.genetics.wustl.edu/seminarphp/admin/photos/$picturename' WHERE uid='$rvar_choose'"); ?> </TABLE> [/code]