Populating form value fields.
| From: | Steve Jackson | Date: | Wed, 11 Dec 2002 15:18:23 +0000 |
| Subject: | Populating form value fields. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-127823@lists.php.net to get a copy of this message | ||
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