Re: [PHP] Populating form value fields.

2002-12-11 Thread Jason Wong 
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

RE: [PHP] Populating form value fields.

2002-12-11 Thread Steve Jackson 
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