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 "$query". 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" <[EMAIL PROTECTED]> wrote in message 002b01c2a128$8c367c60$[EMAIL PROTECTED]">news:002b01c2a128$8c367c60$[EMAIL PROTECTED]... > 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 > [EMAIL PROTECTED] > Mobile +358 50 343 5159 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php