Put quote's around name, I would suspect the space
is throwing off the value equals, example:
<td><input type=text name=Name value=\"$name\"></td>\n
On Fri, 2003-06-20 at 13:31, Matt Hedges wrote:
> Hello. I am making an online database of my wines that I want my friends to
> be able to edit. The page below displays the wines. I want the fields in
> text boxes so later they can be easily edited. However, the text boxes only
> display the first word of the field from the database. For example, in the
> Name text box, let's say the wine's name is Norton Malbec, it only displays
> Norton. Does anyone know how to fix this?
>
> thanks very much
> Matt Hedges
>
>
>
>
>
> <?php
>
> $db = mysql_connect("host", "username", "pw")
> or die ("The Database is momentarily down. Sorry for the delay.");
> mysql_select_db("username",$db);
>
> $sql = "SELECT * FROM wines WHERE id='1'";
> $result = mysql_query($sql);
>
> echo "<b><u><font face=verdana>Wines in Database</font></b></u>:<p>\n";
> echo "<table border=1 bgcolor=white valign=top cellspacing=2
> cellpadding=2>\n";
>
> while ($row = mysql_fetch_array($result))
> {
> extract($row);
> echo "<tr bgcolor=3399cc>\n
> <td><input type=text name=US value=$US></td>\n
> <td><input type=text name=Bodega value=$Bodega></td>\n
> <td><input type=text name=Name value=$Name></td>\n
> <td><input type=text name=Grape value=$Grape></td>\n
> <td><input type=text name=Year value=$Year></td>\n
> <td><input type=text name=Region value=$Region></td>\n
> <td><input type=text name=SubRegion value=$SubRegion></td>\n
> </tr>\n";
> }
> echo "</table>\n";
>
> ?>
>
>
>
>
>
>
>
> --
> ___________________________
> | Matt Hedges
> | http://hedgesinnovations.com
> |
--
Adam Voigt ([EMAIL PROTECTED])
Linux/Unix Network Administrator
The Cryptocomm Group
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
