--- "Norland, Martin" <Martin.Norland@xxxxxxxxxx>
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
