$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

Reply via email to