Re: Populating form value fields.

Hi Steve, you will need to use mysql_fetch_* on the result (where * might be object, row, array, assoc): $query = "SELECT * FROM products WHERE ItemCode='$ItemCode'"; $result = mysql_query($query) // for debug or die("Error in query &quot;$query&quot;. MySQL said: " . mysql_error()); $row = mysql_fetch_assoc($result); Then the form: <form action="eshop_editprodprocess.php" method="post"> <input type="text" name="ItemName" value="<?php echo htmlentities($row['ItemName']); ?>" size="18" class="kapea"> <input type="text" name="ItemCode" value="<?php echo htmlentities($row['ItemCode']); ?>size="18" class="kapea"> <input type="text" name="ItemDesc" value="<?php echo htmlentities($row['ItemDesc']); ?>" size="18" class="kapea"> </form> Check the manual for more details. James "Steve Jackson" <stephen.jackson@violasystems.com> wrote in message news:002b01c2a128$8c367c60$07c810ac@upponetti.upponetti.com... > I am having problems populating form fields. Here is my code: > //$ItemCode is passed to the page with this code > $mysql = mysql_query("SELECT * FROM products WHERE > ItemCode='$ItemCode'"); > $result = mysql_query($mysql); > > Then the form: > <form action="eshop_editprodprocess.php" method="post"> > <input type="text" name="ItemName" > value="<?=$ItemName;?>" size="18" > class="kapea"> > <input type="text" name="ItemCode" > value="<?=$ItemCode;?>" size="18" > class="kapea"> > <input type="text" name="ItemDesc" > value="<?=$ItemDesc;?>" size="18" > class="kapea"> > </form> > > I have tried numerous ways to use $result to get these values to appear > but am stuck. How therefore do I select everything from the database > sorted by ItemCode and then displayed in a form as shown above. > > Regards, > > Steve Jackson > Web Developer > Viola Systems Ltd. > http://www.violasystems.com > stephen.jackson@violasystems.com > Mobile +358 50 343 5159 >