display values on web forms

Anon

hello.

i am writing php codes to place database column values into a web form. so far, it doesn't work completely; only partial information is displayed onto the form.
I have noticed that if the column value has a blank space in it(ie. 'Marc Angelo'),
then only 'Marc' is displayed; everything after the blank space is not displayed.

I've tried a plain 'echo $InfoRow[0]' outside the web form and it displays correctly. I've also tried MYSQL_FETCH_ARRAY without success.Can anyone please help me out? Thank you.

here is my code..
<?

.....

$Info = mysql_query("select ClientName, Company, BillingAddress1,City, Province,PostalCode,Country
from Activation where Usertag='MA'") or die ("unable to display information");

while($InfoRow=mysql_fetch_row($Info))
{
echo ' <body><form method="post" action="update.php">
Full Name: <input name="first" size="40" value='.$InfoRow[0].'><br>
Company: <input name="last" size="40" value='.$InfoRow[1].'><br>
Address: <input name="address" size="100" value='.$InfoRow[2].'><br>
City: <input name="address" size="25" value='.$InfoRow[3].'><br>
Province/State: <input name="address" size="30" value='.$InfoRow[4].'><br>
PostalCode: <input name="address" size="20" value='.$InfoRow[5].'><br>
Country: <input name="address" size="30" value='.$InfoRow[6].'><br>

<input type="Submit" name="submit" value="Update Information">
</form> </body> ';

MYSQL_CLOSE($db);
}//while loop

...
?>

Anon

Never mind.

I figured it out.
the key was not to use ECHO to begin the HTML tags, instead use <? and ?>...

<?.......
while($InfoRow=mysql_fetch_row($Info))
{
?>
<body>
<form method="post" action="update.php">
Full Name: <input name="first" size="40" value=' <? echo $InfoRow[0]?> '><br>.....

-David

aeckhoff

HI, this is not the real cause for the error in the first code:

you must use the quotes in the right way:

echo 'Full Name: <input name="first" size="40" value="'.$InfoRow[0].'">';

This is, why the blanks disrupted your output !