Re: Inserting data at runtime (php,mysql)

From: Date: Tue, 21 Mar 2006 12:40:31 +0000
Subject: Re: Inserting data at runtime (php,mysql)
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-232311@lists.php.net to get a copy of this message
----- Original Message ----- From: "Thorsten Suckow-Homberg" <ts@siteartwork.de> To: "sathyashrayan" <foraci@gmail.com> Cc: <php-general@lists.php.net> Sent: Tuesday, March 21, 2006 6:00 PM Subject: Re: [PHP] Inserting data at runtime (php,mysql)
The connection is successful but the data are not getting inserted into the table. I need to insert all the words into the table. When I change the insert statement with one insert at a time, I can insert values to the database. For exampel: $qure = "INSERT INTO dict VALUES (1,'apple')"; Do I need to check the formatted data in the file? Can any one help me in this regard? I have been working in VC++ for some time.
Replace $str = mysql_query($qure); with $str = mysql_query($qure) or die(mysql_error()); I bet there is an enquoting problem with the data you want to insert... That does not show me any error. I think I need to check for the enter character for each data in the file.


« previous php.general (#232311) next »