On Wednesday 11 December 2002 23:18, Steve Jackson wrote:
> 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.You need to use one of the mysql_fetch_*() functions. See examples in manual. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Prediction is very difficult, especially of the future. - Niels Bohr */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
