[RESOLVED] Retrieved Data

[opie64]

I'm new to php and mysql and i'm having trouble getting data back from my db to a php/html form. The problem is the the data is being trimmed if there is whitespace. Any input would be helpful.

[NogDog]

Pretty tough to debug without any code to look at. What do you mean exactly by "being trimmed if there is whitespace"?

[opie64]

here is the main part of the code.
// select query to see if record exist
$sql2 = ("SELECT FROM cours WHERE cours_num ='$cours_num'");

$result = @($sql2);
$row = @mysql_fetch_array($result);

mysql_close();
?>
<h1 class="center">Edit/Add Record</h1>
<form id="cours.php" method="post" action="course_complete.php" >

<p>Course Number:<br />

<input type="text" readonly="boolean" name="cours_num" size="10" value=<?php echo $cours_num?>><br/>

</p>

<p>Course Title:<br />
<input type="text" name="cours_title" size="10" value=<?php echo $row['cours_title']?>><br/>
</p>

<p>Course Description:<br />

 <input type="text" name="cours_desc" size="50" value=<?php echo $row['cours_desc'] ?>><br/>

</p>

<p >

<input type="submit" value="Add/Edit Records"name="submits" alt="Add/Edit Records" />

</form>

</body>
</html>

what I mean by being trimmed is that if for example that the input to cours_title is bus 456 when retrieved only bus is showing in the input box

[NogDog]

An HTML attribute's value must be quoted if it contains any spaces (and it must be quoted in all cases if using XHTML).

<input type="text" readonly="boolean" name="cours_num" size="10" value="<?php
echo htmlspecialchars($cours_num, ENT_QUOTES); ?>"><br/>

[opie64]

Thank,
that took care of it
DH