Getting double output on text area inputs.

kasmot

Im just wondering why I keep on getting double values whenever I try to retrieve a text area value that is already saved in the Database.

Here is my sample code :

$remarks1 = mysql_result($result,0,"rem1");

Value of rem1 in the database is "ok" but whenever I used this mysql_result function it gives me "okok" output.

LordShryku

Show more code

kasmot

Ok heres my codes...

------------text area box---------
<td width="148" height="394" align="center" rowspan="19"><font face="Verdana">

<textarea wrap="virtual" name="remarks1" rows="31" cols="16"></textarea></font></td></tr>

then I have my perl script to manipulate the data from my form then save it to MySQL Database.

------------accessing fields of a certain id -------------
mysql_select_db("mydb", $db);
$result = mysql_query("SELECT * FROM padbase WHERE idx = '$pid'");
.
.
.

$remarks1 = mysql_result($result,0,"rem1");

Other fields were working fine. This is the only field Im having problem with. I also tried

echo mysql_result($result,0,"rem1");

and its also the same.

kasmot

any idea regarding this?

nemonoman

I have my perl script to manipulate the data from my form<<

I suggest that this looks suspicious;

to check echo out the sql query you use to insert the offending rows. My guess is you'll find the text has been duplicated in the insert query.

kasmot

Thanks for the reply.. I have already check my database if my form is inserting all the data properly and it was ok. And as for the rem1 I have checked that DB contains only "ok" string.. Actually I have tried...

echo mysql_result($result,0,"rem1");

... to check what will I get and it outputs "okok", which duplicates my string. Im really confused regarding this, what Im thinking is that mysql_result function has something to do with this, but it was working fine with the other fields.

kasmot

Any other ideas???