If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: To rectify MySQL Error

Hi,

You had asked me to show the SQL I have used in php. The problem is located in this query.....

update tc_rel_pass_sort set
TestEngineer=\"$name\",Status='".$tcstatus[$i]."',TestedOn='".$tctestedon[$i]."',tcupdate='".$tcupdate[$i]."',NaviscoreStatus='".$naviscorestatus[$i]."',NiEMSStatus='".$niemsstatus[$i]."'
,ResultComments='".$comment[$i]."' where id='.$tcid[$i]."' and passid=".$passid[$i]);

Here in this query you can see the following code segment

,ResultComments='".$comment[$i]."'

Result Comments means the comments given by the test manager. I am supposed to read all the comment given by the test manager and put it in HTML. But the problem pops when there is " ' " sign in comments. So I just want MySQL to read all the comments given by test manager and I shoud not make any change in that comments like deleting the special character or adding some special character......

I think you will be clear with my explanation... Can u help me out. I have to do it today itselt.....