Re: Populating form value fields.
| From: | Jason Wong | Date: | Wed, 11 Dec 2002 15:17:14 +0000 |
| Subject: | Re: Populating form value fields. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-127828@lists.php.net to get a copy of this message | ||
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
*/