RE: [PHP-DB] Retreive email address from MySQL DB

> I have a database: web_feedback, and it has 5 columns: > > Firstname varchar(40) not null > Lastname varchar(40) not null > Email varchar(40) PRIMARY KEY not null > ServList varchar(40) not null > Timestamp not null > > I run a query in a PHP script to retrieve the email address the line of > code > looks like this: > > > $query_time = mysql_query("select time from DB where email='$email'"); > > > This line returns RESOURCE ID #2 in $query_time when I use it to echo it's > value in an email message: > > > $mailcontent = $firstname." ".$lastname." has submitted info as follows: > \n". > > "First Name: ".$firstname."\n". > > "Last Name: ".$lastname."\n". > > "email: ".$email."\n". > > "Selected Services: ".$servList."\n". > > "Time entered: ".$query_time."\n"; > > > > Anyone able to see off hand if I'm doing anything obviously wrong? Well, the first thing is that you're selecting 'time' from your table when the column is named 'timestamp'... Second, you need to use a mysql_fetch_row/array/object/assoc function to retrieve the row from the "result set" returned by mysql_query. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/