Thanks!
"Matt Hedges" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
