[PHP-DB] Email to a list of address in your database.

2003-01-18 Thread Marie Osypian
Hi, I have a list of email address in a mysql database and I would like to create a link that when clicked pulls up your my mail program and mails to everyone in the database. mailto:ARRAY OF EMAIL ADDRESS">Mail to everyone Here is my code: mail To all my list --

RE: [PHP-DB] print new account name on new account page?

2003-01-18 Thread Cal Evans
I don't use the mysql functions anymore (look into php.weblogs.com) but I believe what you are looking for is $row['firstName'], not $firstName. (The extract MAY put them into variables for you but if it does, it's not necessary, just use the $row array. Also, tail the log file on your SQL server

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
Ah, that must be it. I am running a Mac OS X server, which is Darwin based. Guess I should go with sendmail. Thanks a lot. Tony S. Wu [EMAIL PROTECTED] On Saturday, January 18, 2003, at 02:27 PM, Jason Wong wrote: On Sunday 19 January 2003 04:48, Tony S. Wu wrote: I need to send myself an ema

RE: [PHP-DB] [NB] Mail() question

2003-01-18 Thread John W. Holmes
Here is a quick article that discusses how to connect manually to an SMTP server: HOW TO: Test Windows 2000 IIS SMTP Services Manually http://support.microsoft.com/default.aspx?scid=kb;EN-US;286421 Just substitute for your ISPs SMTP server. Run through the tests and you'll be able to see what er

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Micah Stevens
Change the ini_set line to this: $result = ini_set("SMTP", "smtp.earthlink.net"); -Micah On Sat, 2003-01-18 at 14:18, Tony S.Wu wrote: > EarthLink is my DSL ISP, so its smtp server is not likely to block my > mail. > Besides, I can send email with my mail program just fine. > I tried the simi

RE: [PHP-DB] session_cache_limiter

2003-01-18 Thread John W. Holmes
> i am getting a login name to print now on the new account > page but i get the following error message: > Warning: Cannot send session cache limiter - headers already sent > (output started at /users/infoserv/web/register/ca/new_account.php:6) > in /users/infoserv/web/register/ca/new_accoun

[PHP-DB] session_cache_limiter

2003-01-18 Thread Addison Ellis
hello, thank you for your time... i am getting a login name to print now on the new account page but i get the following error message: Warning: Cannot send session cache limiter - headers already sent (output started at /users/infoserv/web/register/ca/new_account.php:6) in /users/infoserv/web

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Jason Wong
On Sunday 19 January 2003 04:48, Tony S. Wu wrote: > I need to send myself an email in one of my PHP page. > So i wrote the following code: > > $result = ini_set(SMTP, "smtp.earthlink.net"); > > if ($result) > { > echo ini_get(SMTP); > $result = mail("[EMAIL PROTECTED]", "test", "test12

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
EarthLink is my DSL ISP, so its smtp server is not likely to block my mail. Besides, I can send email with my mail program just fine. I tried the similar thing on a friend's smtp server where I have access to the log, weird thing is I didn't even see PHP trying to access the smtp server. I need

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
EarthLink is my DSL ISP, so its smtp server is not likely to block my mail. Besides, I can send email with my mail program just fine. I tried the similar thing on a friend's smtp server where I have access to the log, weird thing is I didn't even see PHP trying to access the smtp server. I need

Re: [PHP-DB] [NB] Mail() question

2003-01-18 Thread Micah Stevens
The mail() function returns true if it functions, i.e. if you have all the parameters correct, and that sort of thing. If the SMTP server rejects the email, you'll still get true returned. I ran into this a while back. Try and do a manual connection to the SMTP server from your PHP machine and see

[PHP-DB] [NB] Mail() question

2003-01-18 Thread Tony S . Wu
I need to send myself an email in one of my PHP page. So i wrote the following code: $result = ini_set(SMTP, "smtp.earthlink.net"); if ($result) { echo ini_get(SMTP); $result = mail("[EMAIL PROTECTED]", "test", "test123"); if ($result) echo "mail sent"; } It always print "mail sent", but

[PHP-DB] print new account name on new account page?

2003-01-18 Thread Addison Ellis
hello, i have a form someone fills out. on submit it takes them to a new accounts page that say welcome new member. how can i get their name to print on the new page from the form they just filled out? i have been trying the following but it keeps giving me error messages regardless of how i m

[PHP-DB] Re: SUM(colname)

2003-01-18 Thread Foong
if i am not mistaken SELECT SUM(colname) WHERE value = 'value' only return one row, and that's the sum you want i guess. Foong Cesar Aracena <[EMAIL PROTECTED]> wrote in message 01c2be5d$087868a0$7a00a8c0@NOTEBOOK">news:01c2be5d$087868a0$7a00a8c0@NOTEBOOK... Hi all, I'm trying to add a

Re: [PHP-DB] Getting all rows of a certain column when grouping?

2003-01-18 Thread Jason Wong
On Sunday 19 January 2003 00:00, Leif K-Brooks wrote: > I have a table that stores smileys users can use. I'm trying to make a > > page that lists them in an HTML table something like: > || > | Smiley | Image | > ||---| > | > |:), :-) | IMAGE | > |:(, :-( | IMAGE | > >

Re: [PHP-DB] Re: Identifying clients?

2003-01-18 Thread Jeffrey_N_Dyke
it seems to me that this is to much work for the output. not only will ISPs add complexity, but since you are combining thee seperate items you confining people to a single location. any laptop user may come in from various ips and still be unique. I tend to stay with the information you descri

[PHP-DB] Getting all rows of a certain column when grouping?

2003-01-18 Thread Leif K-Brooks
I have a table that stores smileys users can use. I'm trying to make a page that lists them in an HTML table something like: || | Smiley | Image | ||---| |:), :-) | IMAGE | |:(, :-( | IMAGE | -- I could use a query something like: select * from smile

[PHP-DB] Re: Identifying clients?

2003-01-18 Thread Alan McFarlane
Ah, it seems that certain ISPs can make a client appear from differing addresses (although the cookie - if set - would retain the same data). This extends the problem... Perhaps a lookup on md5(REMOTE_ADDR + CLIENT_IP + FORWARDED_FOR) on a database, plus verification via the cookie? Sheesh - i

[PHP-DB] Identifying clients?

2003-01-18 Thread Alan McFarlane
Having experimented with REMOTE_ADDR, HTTP_X_FORWARDER_FOR, HTTP_CLIENT_IP etc. I'm still unsure as to a foolproof method of identifying clients WITHOUT having them log in to a site. I can only assume that some combination of the above environment variables and judicious use of small cookies is

Re: [PHP-DB] Recursive SQL Expression?

2003-01-18 Thread Alan McFarlane
Thanks Paul, not quite the answer I hoped for, but nevertheless, an excellent description of the problem. Since I'm not using the more powerful DBMS systems, I'll just stick to my original method and with the addition of a simple caching mechanism to limit the load on the server. Thanks again.

[PHP-DB] Re: Send mail with a file

2003-01-18 Thread Manuel Lemos
Hello, On 01/16/2003 07:47 AM, Bruno Pereira wrote: How can i insert a file on a mail, with the command "mail()"? It is possible? You may want to try this class that does exactly what you need: http://www.phpclasses.org/mimemessage -- Regards, Manuel Lemos -- PHP Database Mailing List (ht

[PHP-DB] DB_FETCHMODE_ASSOC result differs for MySQL and MS-SQL

2003-01-18 Thread Gunther
I have a problem with PHP 4.3.0, latest PEAR running under w2k with either MySQL or MS-SQL. With MySQL everything is fine, running the same application just changing the DB server to MS-SQL I get different results. I am using fetchRow(DB_FETCHMODE_ASSOC) to get my DB rows. Under MySQL (correct) a