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