space between words won't appear back

Ali_baba

Hello,

I am facing a very wierd problem.

the problem is that when I save a line (e.g, "This is a line"), it goes fine but when I reterive it back for modification purpose, I get only "This". Does anybody know if I need to use some special PHP function?
Is there anything to do with characterset of the page?

Here is php code:

code for getting the data for modification.

$result = mysql_query("SELECT record_id,sairaanhoitopiiri FROM ktl_epshp where ktl_epshp.record_id = $record_ids");

while ($array = mysql_fetch_array($result))  {
echo <<<EOD
<table align= "center">
<tbody>
  <tr>
  <td>
EOD;
    echo "<input type=\"text\" name=\"sairaanhoitopiiri\" size=\"5\" maxlength=\"10\" value=".$array['sairaanhoitopiiri']." ></td>";
    echo <<<EOD
    </tr>
    <tr>
    <td>Toimipaikkatyyppi:</td>
    <td>..................

mrhappiness

Originally posted by Ali_baba
the problem is that when I save a line (e.g, "This is a line"), it goes fine

how did you verify that?
where from do you know that "This is a line" is stored in your database?

bretticus

$array['sairaanhoitopiiri']

Contains only the first word of that column from the record?

Ali_baba

Originally posted by mrhappiness
how did you verify that?
where from do you know that "This is a line" is stored in your database?

Hello mrhappiness,

I cked it from phpmyadmin. It is going fine. I am not sure if myphpadmin is doing something so that the data can go correctly in database as it is entered.

Ali_baba

Originally posted by bretticus
$array['sairaanhoitopiiri']
Contains only the first word of that column from the record? [/B]

no it is saving the whole sentence

mrhappiness

above your echo do

echo '<pre>';
print_r($array);
echo '</pre>';

is the sentence there in full length?

what does the generated html source look like?

Ali_baba

I figured out the solution

echo "<input type=\"text\" name=\"sairaanhoitopiiri\" size=\"5\" maxlength=\"10\" value=\"".$array['sairaanhoitopiiri']."\" ></td>";

Double quotes in value.

Thanks mr happiness and bretticus for the time

I will do stuff with textarea as well (for writing multiline comments) later. Do you guys have suggestions?