Sorry, I didn't read correctly the question-
There are plenty way to do it
for example :

$query = mysql_query($sql) ;
$ligne=mysql_fetch_array($query) ;
echo $ligne['company'] ;
echo $ligne['email'] ;

or
echo mysql_result($query,0,1);


----- Original Message -----
From: "rija" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>; "Ben C." <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 1:34 PM
Subject: Re: [PHP] Using info from a MySQL Query


> Put your variables into {} like this '{$_POST['email'] }',
>
>  $sql ="SELECT company, name, email FROM $table_name
>       WHERE email = '{$_POST[email]}' AND password =
> password('{$_POST[password]}')";
>
> ----- Original Message -----
> From: "Ben C." <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, November 06, 2002 12: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
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to