$sql ="SELECT company, name, email FROM $table_name WHERE email = '$_POST[email]' AND password = password('$_POST[password]')"; $result = mysql_query($sql) or die("Error: $sql<BR>".mysql_error()); extract(mysql_fetch_row($result)); print "$company $mail";
rick People will forget what you said. People will forget what you did. But people will never forget how you made them feel. ----- Original Message ----- From: "Ben C." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 7:09 PM Subject: [PHP] Using info from a MySQL Query 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. -- 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