Re: insert not working
| From: | bala chandar | Date: | Thu, 05 May 2005 11:07:59 +0000 |
| Subject: | Re: insert not working | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214514@lists.php.net to get a copy of this message | ||
Hi,
On 5/5/05, Ross <ross@aztechost.com> 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";
> }
>
> why yould this not work? I can retrievethe data but not write any data to
> the database??
Please mention the error message clearly. what error are you getting.
I think there might be some data type mismatch between ur php code and
mysql data type
> R.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
bala> balachandar muruganantham
blog> lynx http://chandar.blogspot.com
web> http://www.chennaishopping.com