> 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
> 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
> value in an email message:
> $mailcontent = $firstname." ".$lastname." has submitted info as
> "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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php