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