Print echo in Html doesn't work

tawey

Hai,
I am new in PHP programming and I have some question to ask :
1. Are there any program that can convert MSaccess database to mysql? where can I get it?
2. Look at the code.

code :

mysql_connect("localhost","Joe","****");
mysql_select_db("test");

$result = mysql_query("Select * from table1 where name='txtCode'");
$data = mysql_fetch_array($result);

<form name="form1" method="post" action="">
<input type="text" name="txtName" value = <? echo $data["Name"] ?> >

<?
// program output only result "Fillippo" I want full name like "Fillippo inzaghi"

// looks like it doesn't include space and after space.
// (for information I use char data type in name column)

</form>

Thanks!

drew010

Originally posted by tawey
Hai,
I am new in PHP programming and I have some question to ask :
1. Are there any program that can convert MSaccess database to mysql? where can I get it?

See http://www.hotscripts.com/Detailed/13397.html
and
http://www.hotscripts.com/Detailed/16571.html.

2. Look at the code.

The reason there is the space is because in your <input type="text" name="txtName" value = <? echo $data["Name"] ?> > you didnt enclose the value= with quotes. since there is a space in the data you want shown and no quotes, it thinks the last name is a different form element that doesnt exist so it ignores it. If you view the source it would be there. Change that line to:
<input type="text" name="txtName" value="<? echo $data["Name"] ?>"> and now your full name should show up.