Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread rija
"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['em

Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread Chris Knipe
$sql = "query" $result = mysql_query($sql) while ($data = mysqlfetch_array($result)) { echo $data['colum']; } - Original Message - From: "Ben C." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 3:09 AM Subject: [P

Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread Rick Emery
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: [PH

Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread Marco Tabini
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

Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread rija
en 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[ema

RE: [PHP] Using info from a MySQL Query

2002-11-05 Thread John W. Holmes
> 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)

[PHP] Using info from a MySQL Query

2002-11-05 Thread Ben C .
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