Editing records - can someone look at the code please
Posted: Mon Mar 07, 2005 7:31 am
Thanks - I made the changes to the code below some small errors but I still keep getting the same error message there is no such thing as template so why is it still giving this message??? any ideas
I get this message when I try and load the page
I get this message when I try and load the page
SELECT * FROM people WHERE person_id=''
Table 'template.people' doesn't exist
Code: Select all
<?
$host = "xxx"; //your database host
$user = "xxx"; // your database user name
$pass = "xxx"; // your database password
$db = "contact_management_system"; // your database name
if(isset($_GETї'person_id'])){
$person_id=$_GETї'person_id'];
}
if ($_POSTї'Submit'] == 'Submit'){
foreach ($_POST as $formName => $phpName){
$$formName = $phpName;
}
$sql = "UPDATE people SET "
. " salutation='" . $salutation ."',"
. " firstname='" . $firstName ."',"
. " surname='" . $surname ."',"
. " organisation='" . $organisation ."',"
. " role='" . $role ."',"
. " address1='" . $address1 ."',"
. " address2='" . $address2 ."',"
. " city='" . $city ."',"
. " telephone='" . $telephone ."',"
. " mobile='" . $mobile ."',"
. " fax='" . $fax ."',"
. " dateoflastcontact='" . $dateoflastcontact ."',"
. " datecontactagain='" . $datecontactagain ."',"
. " notes='" . $notes ."',"
. " email='" . $email ."',"
. " org_id='" . $org_id ."',"
. " WHERE person_id=" . $person_id;
echo "<br><div align=center>" . $sql . "<br>";
mysql_query($sql) or die('could not insert' . mysql_error());
echo " <div align=left><table width=70% border=1 cellpadding=10 align=center>"
. " <tr>"
. " <td width=40%>"
. " <font face=arial size=2><b>"
. " person_id"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $person_id . " </font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " salutation"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $salutation . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " firstname"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $firstname . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " surname"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $surname . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " organisation"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $organisation . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " role"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $role . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " address1"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $address2 . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " city"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $city . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " postcode"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $postcode . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " telephone"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $telephone . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " mobile"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $mobile . "</font>"
. " </td>"
. " </tr>"
." <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " fax"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $fax . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " dateoflastcontact"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $dateoflastcontact . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " datecontactagain"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $datecontactagain . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " notes"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $notes . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " email"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $email . "</font>"
. " </td>"
. " </tr>"
. " <tr>"
. " <td>"
. " <font face=arial size=2><b>"
. " org_id"
. " </font>"
. " </td>"
. " <td>"
. " <font face=arial size=2>"
. " " . $org_id . "</font>"
. " </td>"
. " </tr>"
. " </table>";
}
// else{
$sql = "SELECT * FROM people WHERE person_id='" . $person_id . "'";
echo "<br><div align=center>" . $sql . "<br>";
$memb = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($memb);
echo "\n"
. " </div>\n"
. " <form name=form2 method=post action=editpeople.html?person_id=" . $person_id . ">\n"
. " <table width=70% border=1 cellpadding=10 align=center>\n"
. " <tr>\n"
. " <td width=40%>\n"
. " <font face=arial size=2><b>\n"
. " Person ID\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=person_id type=text id=person_id value='" . $rowї'person_id'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td width=40%>\n"
. " <font face=arial size=2><b>\n"
. " Salutation\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=salutation type=text id=salutation value='" . $rowї'salutation'] . "'></font>\n"
. " <tr>\n"
. " <td width=40%>\n"
. " <font face=arial size=2><b>\n"
. " First Name\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=firstame type=text id=firstName value='" . $rowї'firstName'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Surame\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=surname type=text id=surname value='" . $rowї'surname'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Organisation\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=organisation type=text id=organsation value='" . $rowї'organisation'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Role 1\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=role type=text id=role value='" .
$rowї'role'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Address 1\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=address1 type=text id=address1 value='" . $rowї'address1'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Address2\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=address2 type=text id=address2 value='" . $rowї'address2'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " City\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=city type=text id=city value='" .
$rowї'city'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Telephone\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=telephone type=text id=telephone value='" . $rowї'telephone'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Mobile\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=mobile type=text id=mobile value='" .
$rowї'mobile'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Fax\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=fax type=text id=fax value='" .
$rowї'fax'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Last Contact\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=datepflastcontact type=text id=dateoflastcontact value='" .
$rowї'dateoflastcontact'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Contact Again\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=datecontactagain type=text id=datecontactagain value='" .
$rowї'datecontactagain'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Notes\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=notes type=text id=notes value='" .
$rowї'notes'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " Email\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=email type=text id=email value='" .
$rowї'email'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td>\n"
. " <font face=arial size=2><b>\n"
. " OID\n"
. " </font>\n"
. " </td>\n"
. " <td>\n"
. " <font face=arial size=2>\n"
. " <input name=org_id type=text id=org_id value='" .
$rowї'org_id'] . "'></font>\n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td colspan=2>\n"
. "  \n"
. " </td>\n"
. " </tr>\n"
. " <tr>\n"
. " <td colspan=2 align=center>\n"
. " <input type=reset name=Reset value=Reset>\n"
. " <input type=submit name=Submit value=Submit>\n"
. " </td>\n"
. " </tr>\n"
. " </table>\n"
. " </form>\n";
// }
?>
</td>
<p>