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
|
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
