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

Reply via email to