Hi all!
The problem is the following : I've a MS Access 2000 database whose tables are filled with the data coming from php-handled web forms.
I've another form (I use that to update de user data) whose controls should be filled in with the database content, but... Here there's the question: I have a code similar to the following :
<?php
$Query=odbc_exec($Res, $Statement)
/statement is simply "select from table_name" */
$var=odbc_result($Query, "field_name");
printf("<form><input type=text name=myname value=$var></form>");
?>
the problem is that, if $var NOT has blanks (i.e. : "aaaaaaaaaaaaaaaaaaaaaaa") the EditBox is correctly filled. In the other case (i.e. : "aaaaaaaaaaaa bbbbbb cccc"), the EditBox will be filled only with "aaaaaaaaaaaa" (as if the blanks were truncated), also if one echo $var produces aaaaaaaaaaaa bbbbbb cccc.
May someone help me?
Thanks all!
P.S. : I apologize for my bad english!!!