pre fill a comments box

[mwl707]

Hi I am using a bit of java to prefill a comments box called 'comments' . I get the value from the code below

 

$result = mysql_query('select * from event');

while ($i < mysql_num_fields($result)) {

    $meta = mysql_fetch_field($result, $i);

     

$label = $meta->name  ;

$i++;

$lcondition = "jobnumber = $importedjobnumber";

$lresult = mysql_query("SELECT * FROM event WHERE $lcondition")  ;

$row = mysql_fetch_array($lresult) ;

$rte = $row["$label"] ;

$$label  = $rte ;

 

At this point I KNOW that the variable $comments contains text. But to be double sure I do this

 

$comments = $row['comments'] ;

 

I have a form with a text box called comments and am using php/java to fill it

 

echo "<script> document.form1.comments.value= '$comments' </script>" ;

 

BUT nothing appears in the box. I have tried everything I know to get a display but nothing. Now the strange this is if i do this

 

$comments = "this is a test" ;

echo "<script> document.form1.comments.value= '$comments' </script>" ;

 

it works !, Can anybody please tell me what I am doing wrong ?

 

 

[cbolson]

Hi,

You say:

At this point I KNOW that the variable $comments contains text. But to be double sure I do this

 

$comments = $row['comments'] ;

How do you *know* that it contains text?

Have you done echo $row["comments"]; on the page to test it has a value?

 

Chris

[mwl707]

Yes I have testes this with echo and it has a value

 

 

[ldb358]

can you please post the entire unaltered script so that i can see it

[haku]

Hi I am using a bit of java to prefill a comments box called 'comments'

 

Sure looks a lot like javascript to me.