Cheers Jason.
Sorted.
Steve Jackson
Web Developer
Viola Systems Ltd.
http://www.violasystems.com
[EMAIL PROTECTED]
Mobile +358 50 343 5159
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 11. joulukuuta 2002 17:17
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Populating form value fields.
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php