Re: insert not working

From:	Marek Kilimajer	Date:	Thu, 05 May 2005 10:43:12 +0000
Subject:	Re: insert not working
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-214508@lists.php.net to get a copy of this message

Ross wrote:

$query = "INSERT INTO sheet1 (title, fname, sname, job_title, organisation, street, postcode, city, telephone, mobile, fax, email, web, add_info) VALUES ('$title', '$fname', '$sname', '$job_title', '$organisation', '$street', '$postcode', '$city', '$telephone', '$mobile', '$fax', '$email', '$web', '$add_info')"; $result= mysql_query($query); if($result){ echo "sucess"; }

else {

    echo mysql_error() . "<br>\n$query";

}

why yould this not work? I can retrievethe data but not write any data to the database?? R.