Re: Using info from a MySQL Query
| From: | Marco Tabini | Date: | Wed, 06 Nov 2002 02:42:11 +0000 |
| Subject: | Re: Using info from a MySQL Query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-122906@lists.php.net to get a copy of this message | ||
I think you might want something like this:
$sql ="SELECT company, name, email FROM $table_name
WHERE email = '$_POST[email]' AND password =
password('$_POST[password]');
$rs = mysql_query ($sql, mysql_connect ('server', 'user', 'pass');
$a = mysql_fetch_array ($rs);
echo $a['company'];
echo $a['name'];
Minus some error checking, this is pretty much it.
Marco
-----------
php|architect -- The Monthly Magazine For PHP Professionals
Visit us on the web at http://www.phparch.com!
On Tue, 5 Nov 2002, 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.
>
>
>