Nah I definately dont - heres the code
Code: Select all
<?php
error_reporting(E_ALL);ini_set('display_errors', TRUE);
/* Connecting, selecting database */
$link = mysql_connect("****", "****", "****")
or die("Could not connect : " . mysql_error());
mysql_select_db("contact_management_system",$link) or die("Could not select database");
$sql =
"INSERT INTO people
(person_id, salutation,
firstname, surname, organisation, role,
address1, address2, city, postcode, telephone,
mobile, fax, dateoflastcontact, datecontactagain,
email)
VALUES
('$person_id','$salutation',
'$firstname','$surname', '$organisation',
'$role', '$address1', '$address2', '$city',
'$postcode', '$telephone', '$mobile', '$fax',
'$dateoflastcontact', '$datecontactagain',
'$email') ";
$result = mysql_query($sql,$link) or die ( mysql_error($link));
header ("location: http://editweb.soi.city.ac.uk/organisat ... people.php");
?>
Could it be anything else
the funny thing is I do exactly the same here and it works fine:
code below
Code: Select all
<?php
/* Connecting, selecting database */
$link = mysql_connect("*******", "*****", "******")
or die("Could not connect : " . mysql_error());
mysql_select_db("contact_management_system",$link) or die("Could not select database");
$sql = "INSERT INTO organisations (org_id,person_id, orgname, web_url, sector, location, current_placement, no_ofstudents, notes ) VALUES ('$org_id','$person_id','$orgname','$web_url','$sector', '$location', '$current_placement', '$no_ofstudents', '$notes')";
$result = mysql_query($sql,$link) or die ( mysql_error($link));;
header ("location: http://www.soi.city.ac.uk/organisation/pl/CMS/Uorgs.php");
?>