RE: [PHP-DB] stumped-mail and database
| From: | Stuart Felenstein | Date: | Mon, 06 Dec 2004 20:37:48 +0000 |
| Subject: | RE: [PHP-DB] stumped-mail and database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37620@lists.php.net to get a copy of this message | ||
--- "Norland, Martin" <Martin.Norland@STJUDE.ORG>
wrote:
> What is $rsVendorJobs
It's a "recordset" which for lack of a better
definition is a sql query.
>
> Is $rsVendorJobs just the result of a mysql_query()?
> If so, you probably
> just want to be using:
>
> $to = $rsVendorJobs['Conmail'];
Nope, though it didn't throw an error, it was blank.
Here is the code. There is actually a transaction that
takes place (insert into database) the email is set up
as an after trigger to the insert. I'm leaving the
transaction out.
$query_rsVendorJobs = sprintf("SELECT
VendorJobs.Contact, VendorJobs.Conmail,
CONCAT_WS('-', VendorJobs.JobID,
VendorJobDetails.OptRefCode,
VendorJobs.JobTitle) AS RefEm,
VendorSignUp.CompanyName, VendorJobs.JobID,
VendorJobs.JobTitle,
VendorJobDetails.OptRefCode FROM VendorJobs
INNER JOIN VendorJobDetails ON (VendorJobs.JobID
= VendorJobDetails.JobID) INNER JOIN
VendorSignUp ON (VendorJobs.VendorID =
VendorSignUp.VendorID) WHERE (VendorJobs.JobID =
%s) ", $colname__rsVendorJobs);
$rsVendorJobs =
$XXXX->SelectLimit($query_rsVendorJobs) or
die($XXXX->ErrorMsg());
$totalRows_rsVendorJobs =
$rsVendorJobs->RecordCount();
// end Recordset
%s = the JobID I've selected on the previous page and
passed over with $_POST
Hope this is enough. Not sure what else to send.
Stuart