oops, I meant mysql_fetch_array($result,MYSQL_ASSOC); -----Original Message----- From: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Sent: Tuesday, November 05, 2002 7:10 PM To: John Coder; Ben C. Cc: [EMAIL PROTECTED] Subject: RE: Using Query Results in a Form
in php <?php $result = mysql_query($sql); $row = mysql_fetch_array($result,$sql); ?> <input type="textbox" name="email" value"<?=$row["email"]?>"> -----Original Message----- From: John Coder [mailto:jcoder@;insightbb.com] Sent: Tuesday, November 05, 2002 7:04 PM To: Ben C. Cc: [EMAIL PROTECTED] Subject: Re: Using Query Results in a Form On Tue, 2002-11-05 at 20:23, Ben C. wrote: > I am using the following query: > > $sql ="SELECT company, name, email FROM $table_name > WHERE email = '$_POST[email]' AND password = password('$_POST[password]')"; > > Then I am echoing the $email on my form (it works because the person has posted their e-mail name when logging in). How can I echo the company and email on to my form as well. Please help. > Is this query on your form or the form that the person has filled out? John Coder --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
