I am trying to load a record from an Access database into a form for update. It does not load the description field which is of type MEMO. It loads only the first word of a string which contains many words for TEXT fields. Example, it loads only Tom instead of Tom Hanks which is what is in the database. Beloe is the code:
<?php
//set up the connection for Movies
$connID = odbc_connect("MovieCat","","");
$query = "Select * From Movies";
$query .= " Where MovieID=" . $movieID;
//query the database
$queryID = odbc_exec($connID, $query);
//set binmode
odbc_binmode($queryID, ODBC_BINMODE_CONVERT);
//set longreadlen
odbc_longreadlen($queryID, 600);
$rc = odbc_fetch_row($queryID);
$fieldZero = odbc_result($queryID,"MovieID");
$fieldOne = odbc_result($queryID,"Title");
$fieldTwo = odbc_result($queryID,"ReleaseDate");
$fieldFour = odbc_result($queryID,"Director");
$fieldFive = odbc_result($queryID,"Starring");
$fieldSix = odbc_result($queryID,"Description");
$fieldSeven = odbc_result($queryID,"Image");
$fieldEight = odbc_result($queryID,"GenreIDfk");
print("<P ALIGN = CENTER>");
print("<B>Please Make The desired Changes</B><BR>");
print("<P ALIGN = LEFT>");
print("<FORM ACTION=\"ProcessMovieUpdate2.php\" METHOD=POST>");
print("Movie ID <INPUT TYPE=TEXT NAME=\"MovieID\" VALUE=$fieldZero SIZE=25><BR>");
print("Title <INPUT TYPE=TEXT NAME=\"Title\" VALUE=$fieldOne SIZE=25><BR>");
print("GenreID <INPUT TYPE=TEXT NAME=\"GenreIDfk\" VALUE=$fieldEight SIZE=50><BR>");
print("Release Date <INPUT TYPE=TEXT NAME=\"ReleaseDate\" VALUE=$fieldTwo SIZE=50><BR>");
print("Description <TEXTAREA NAME=\"Description\" VALUE=$fieldSix ROWS=5 COLS=40></TEXTAREA><BR>");
print("Director <INPUT TYPE=TEXT NAME=\"Director\" VALUE=$fieldFour SIZE=30><BR>");
print("Starring <INPUT TYPE=TEXT NAME=\"Starring\" VALUE=$fieldFive SIZE=50><BR>");
print("Image <INPUT TYPE=TEXT NAME=\"Image\" SIZE=20><BR>");
print("<INPUT TYPE=RESET VALUE=\"Clear Form!\">");
print("<INPUT TYPE=SUBMIT NAME=\"SUBMIT\" VALUE=\"Submit!\">");
print("</FORM>");
//free the result space
odbc_free_result($queryID);
odbc_close($connID);
?>