RE: [PHP-DB] stumped-mail and database

--- "Norland, Martin" <Martin.Norland@STJUDE.ORG> wrote: > (Bear with me on this, because I've got nothing > remaining to go on...) > What do you get from: > > var_dump($query_rsVendorJobs); > var_dump($totalRows_rsVendorJobs); > var_dump($XXXX->SelectLimit($query_rsVendorJobs)); > var_dump($rsVendorJobs); // should match above. > // If this one is huge - we may want to hold off on > this one > var_dump($XXXX); > I held off on the vary_dump($XXXX); The most revealing were: var_dump($query_rsVendorJobs); This is just basically the sql statement: string(513) "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 = 10042) " Yet the JobID is correct so that's a positive The other var_dump is: var_dump($rsVendorJobs); this returned alot. I snipped most of it but if you look , well if I look, all the fields have the correct values: object(kt_adorecordset_mysql)(33) { ["dataProvider"]=> string(6) "native" ["fields"]=> array(14) { [0]=> string(12) "Hamas Zwicki" ["Contact"]=> string(12) "Hamas Zwicki" [1]=> string(18) "stuart4m@yahoo.com" ["Conmail"]=> string(18) "stuart4m@yahoo.com" [2]=> string(24) "10042-A99839-Entry Clerk" ["RefEm"]=> string(24) "10042-A99839-Entry Clerk" [3]=> string(13) "Talman Zwicki" ["CompanyName"]=> string(13) "Talman Zwicki" [4]=> string(5) "10042" ["JobID"]=> string(5) "10042" [5]=> string(11) "Entry Clerk" ["JobTitle"]=> string(11) "Entry Clerk" [6]=> string(6) "A99839" ["OptRefCode"]=> string(6) "A99839" } ["blobSize"]=> int(100) ["canSeek"]=> bool(true) ["sql"]=> string(540) "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 ...[snip] Stuart