[RESOLVED] Edit form not displaying all info

[lmayer4]

Afternoon,

I'm sure this is simple. I have an edit form when I run the query in SQL all the information is displayed when I run it PHP the first word then nothing shows up. For example if the data in the field says : 2569 Nutley Street when I run it in PHP it only displays 2569 and nothing else.

Below is a snippet of the code. Any thoughts would be most welcome.

Thanks

Laura

<?
/* connect to db */
include ("connect.php");

/* construct and run our query */
$result = mssql_query("select * from dbo.tblIncidentReport 
		where IncidentID = '".urldecode($_REQUEST['IncidentID'])."'");
$myrow = mssql_fetch_array($result);
/* make sure data was retrieved */
?>
Case Status:<input name="CaseStatus" value = <? echo $myrow["CaseStatus"] ; ?>>

[devinemke]

run the data thru [man]htmlspecialchars[/man] before display

[lmayer4]

LIke so:?

<? echo htmlspecialchars($myrow["CaseStatus"]) ; ?>

If so I tried it and still it only returns the first word before the space.

Thanks though

Laura

[Najjar]

The url is not being resolved correctly
Make sure that you have " around the text fields in you form
i.e <input type="text" name="address" values="<? echo address; ?>">

[lmayer4]

Ahhh....Thanks so much.

That was it.

Laura

[Najjar]

Glad you fixed it.