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

2004-12-08 Thread Stuart Felenstein
--- Stuart Felenstein [EMAIL PROTECTED] wrote: --- Jason Wong [EMAIL PROTECTED] wrote: Also just to be certain that you *are* running those lines of code change the echo $to, to echo Before $to echo After $to or something. Some may remember my problem the other day where I

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

2004-12-07 Thread Stuart Felenstein
--- Jason Wong [EMAIL PROTECTED] wrote: What happens when you do this: $to = $rsVendorJobs-fields('Conmail'); echo $to; echo $rsVendorJobs-fields('Conmail'); $to = $rsVendorJobs-fields('Conmail'); echo $to; Same thing: Call to a member function on a non-object in.. Stuart -- PHP

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

2004-12-07 Thread Jason Wong
On Tuesday 07 December 2004 19:15, Stuart Felenstein wrote: --- Jason Wong [EMAIL PROTECTED] wrote: Please be explicit, do you mean this what you get?: What happens when you do this: $to = $rsVendorJobs-fields('Conmail'); Call to a member function on a non-object echo $to; Nothing, as

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

2004-12-07 Thread Stuart Felenstein
--- Jason Wong [EMAIL PROTECTED] wrote: Also just to be certain that you *are* running those lines of code change the echo $to, to echo Before $to echo After $to or something. Well now I feel like a damn jackass. I just discovered something that doesnt fix the issue, yet reveals the

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

2004-12-06 Thread Bastien Koert
I prefer to assign the db values to loca variables to ensure that I am sending out exactly what I need to. Bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] stumped-mail and database Date: Mon, 6 Dec 2004 10:05:57 -0800 (PST) I'm trying to send mail out

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

2004-12-06 Thread Norland, Martin
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Here is what I tried: $to = $rsVendorJobs-Fields('Conmail'); $subject = $rsVendorJobs-Fields('RefEm'); $body = '$cl'; $headers = From: [EMAIL PROTECTED]; mail($to,$subject,$body,$headers); echo Mail sent to $to;

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

2004-12-06 Thread Jochem Maas
er, I don't know if it would interest you but here is a class I have been using for ages now (not that I have trouble using mail() for simple jobs) because its simple, packed with functionality and works well: http://phpmailer.sourceforge.net/ the following page hopefully demonstrates how

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

2004-12-06 Thread Stuart Felenstein
--- Bastien Koert [EMAIL PROTECTED] wrote: I prefer to assign the db values to loca variables to ensure that I am sending out exactly what I need to. Well the binding is one where clause that pulls the correct record for the transaction. Following what you are saying, how does that

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

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: 1) change $to = $rsVendorJobs-Fields('Conmail'); To $to = {$rsVendorJobs-Fields('Conmail')}; Or just $to = $rsVendorJobs-Fields('Conmail'); 2) change $body = '$cl'; To $body = $cl; Well I'm sure this is not the

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

2004-12-06 Thread Norland, Martin
: [PHP-DB] stumped-mail and database --- Norland, Martin [EMAIL PROTECTED] wrote: 1) change $to = $rsVendorJobs-Fields('Conmail'); To $to = {$rsVendorJobs-Fields('Conmail')}; Or just $to = $rsVendorJobs-Fields('Conmail'); 2) change $body = '$cl'; To $body = $cl

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

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] 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

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

2004-12-06 Thread Norland, Martin
All I can recommend from here is heavy use of printr() or var_dump() on your variables. $totalRows_rsVendorJobs = $rsVendorJobs-RecordCount(); // end Recordset This clearly means $rsVendorJobs is an object of some sort, probably some custom recordset object as you've said - so your best bet is

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

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] wrote: All I can recommend from here is heavy use of printr() or var_dump() on your variables. They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. Obviously, also, you'll want to print

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

2004-12-06 Thread Norland, Martin
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. (Bear with me on this, because I've got nothing remaining to go on...) What do you get from:

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

2004-12-06 Thread Jochem Maas
Stuart Felenstein wrote: --- Norland, Martin [EMAIL PROTECTED] wrote: All I can recommend from here is heavy use of printr() or var_dump() on your variables. They are NULL. That is the problem. I can't for the life of me , figure out a way to initialize these variables. be more specific - its

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

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED] 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($-SelectLimit($query_rsVendorJobs));

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

2004-12-06 Thread Norland, Martin
var_dump($rsVendorJobs); object(kt_adorecordset_mysql)(33) { [dataProvider]= Looks like you're using the ADODB library ( http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or similar. ( That may not be the official site, I just bounced around a bit. ) All your previous code

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

2004-12-06 Thread Jochem Maas
I just thought, if your query object ($) is returning a resultset object then maybe you have to 'loop' the resultset object in order to retrieve the 'row' object(s) from which you can retrieve the data. your resultset object doesn't have a GetRowAssoc() method? [ defined as