mysql_query returns an array, not simply a string ... my recommendation is do your error checking near your mysql_query statement (i.e. if(!mysql_query(whatever) die();) then do an else to loop through the results. loop using mysql_fetch_row(RESULT), where result is your "RESOURCE ID", echoing RESULT[x]. hope this helps. Matthew Moldvan. System Administrator, Trilogy International. > -----Original Message----- > From: Info@Best-IT [mailto:info@best-it.biz] > Sent: Tuesday, January 07, 2003 11:34 PM > To: php-db@lists.php.net > Subject: 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? > > /T > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
