RE: [PHP-DB] Mail problem

2002-08-01 Thread Russ
Could you not simply extract all the email addresses from the DB as you would any other data, then loop thru the result set calling PHP's mail() function for every record retrieved? while($row=mysql_fetch_assoc($result)) { extract($row); //Presume's '$email ' is the name of the field in which

Re: [PHP-DB] Mail problem

2002-08-01 Thread Bartek Pawlik
Of course, but PHP is on Linux machine where I don't have sendmail, because my mail server is on different machine, and that's my problem Bartek - Original Message - From: Russ [EMAIL PROTECTED] To: Bartek Pawlik [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 01, 2002

RE: [PHP-DB] Mail problem

2002-08-01 Thread Russ
Just looking at our php.ini file and we use an external machine to send mail with when calling the mail() function. I think you just need to change the directive for the path/URI to the mail server you wish PHP to use, in your php.ini file. HTH :-) Russ -Original Message- From: Bartek

[PHP-DB] php mysql external server

2002-08-01 Thread Meethoo Salim
hello there , i have my Mysql server installed on a different machine- how ca li access it? can someone help me out please regards -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] php mysql external server

2002-08-01 Thread Beau Lebens
Meethoo as it says in the PHP documentation, you can access a MySQL server whether it's on the same machine as the PHP install or not. ie. mysql_connect('localhost', $user, $pass) OR mysql_connect('111.111.111.111', $user, $pass) Beau // -Original Message- // From: Meethoo Salim

[PHP-DB] Date Add

2002-08-01 Thread John Fishworld
I thought I had this working, but it seems unfortunately not !!! I'm trying to list events for each month and my select query is as follows SELECT DISTINCT t_city_name,t_city_id_city FROM t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city = t_zipcodecity_id_city) AND

[PHP-DB] Multiple select ?

2002-08-01 Thread Dave Carrera
Hi All I have a situation where I need to do select on my mysql db. Here is what I am trying to do Select * from table_name where col1=1 and col2=1 and col3=0 But this refuses to work. If I change the above to this. Select * from table_name where col1=1 OR col2=1 and col3=0 What I get is

[PHP-DB] PHP --with-pgsql

2002-08-01 Thread Jan Feller
Hello! I´have a problem compiling PHP 4.1.2 with PostgreSQL. Running the Makefile returns this problem: ld: fatal: library -lpq: not found I edited the Makefile adding some lib-paths. But none of ´em worked. Which library is missing and what can I do? Thx in advance Regards Jan -- GMX

Re: [PHP-DB] PHP --with-pgsql

2002-08-01 Thread Rasmus Lerdorf
It is obviously missing libpq You need to installed the postgresql libraries. If you are installing from packages, install the postgresql-devel package. -Rasmus On Thu, 1 Aug 2002, Jan Feller wrote: Hello! I´have a problem compiling PHP 4.1.2 with PostgreSQL. Running the Makefile returns

Re: [PHP-DB] Multiple select ?

2002-08-01 Thread Jason Wong
On Thursday 01 August 2002 17:06, Dave Carrera wrote: Hi All I have a situation where I need to do select on my mysql db. Here is what I am trying to do Select * from table_name where col1=1 and col2=1 and col3=0 But this refuses to work. How does it refuse to work? Any error messages?

Re: [PHP-DB] Mail problem

2002-08-01 Thread Manuel Lemos
Hello, On 12/31/1969 09:00 PM, Unknown Sender wrote: Of course, but PHP is on Linux machine where I don't have sendmail, because my mail server is on different machine, and that's my problem If you are allowed, you can install sendmail in your machine and configure to route all mail

[PHP-DB] Novice to PHP. Database connection help needed

2002-08-01 Thread Ing. Rajesh Kumar
Hi everybody I am normally working with ASP and ASPX. Now I want to try PHP. I installed and tried some simple scripts and they are running fine. Now it is time to working with database but i could not find something helpful in the manual. Can someone give me a link or better a code how to

Re: [PHP-DB] Novice to PHP. Database connection help needed

2002-08-01 Thread Josh Trutwin
You might want to look at some of the free abstraction layers out there like ADODB (http://php.weblogs.com/ADODB). http://www.devshed.com/Server_Side/PHP/ has a couple nice articles on using ADODB. Good luck. Josh Hi everybody I am normally working with ASP and ASPX. Now I want to try PHP.

Re: [PHP-DB] Novice to PHP. Database connection help needed

2002-08-01 Thread Jason Wong
On Thursday 01 August 2002 19:52, Ing. Rajesh Kumar wrote: Hi everybody I am normally working with ASP and ASPX. Now I want to try PHP. I installed and tried some simple scripts and they are running fine. Now it is time to working with database but i could not find something helpful in the

[PHP-DB] Re: please help.. serial number generator

2002-08-01 Thread Hugh Bothwell
Rainydays Sunshine [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I need to create some kind of 10 digits serial number where I can generate and check that it is valid. Sort of like a checksum.. How many unique values do you need, and how hard-to-fake? I

[PHP-DB] Help Needed

2002-08-01 Thread Manoj Japher
hi, I have started working with PHP-MySQL recently. I have been getting a warning message which i am not able to debug. Could some one pls help me out? The message is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/verify.php

[PHP-DB] get row id back on INSERT?

2002-08-01 Thread Michael Zornek
Ok, So I'm creating the usually MySQL backend I have a page that I want to create a new record with some name, then I'd like to capture the new records id (which is an auto-increment int field) so I can pass it to the edit.php?id=$theId URL I could run a reach for the newly inserted row

Re: [PHP-DB] get row id back on INSERT?

2002-08-01 Thread Jason Wong
On Friday 02 August 2002 03:27, Michael Zornek wrote: Ok, So I'm creating the usually MySQL backend I have a page that I want to create a new record with some name, then I'd like to capture the new records id (which is an auto-increment int field) so I can pass it to the

[PHP-DB] Whats the best way to update...

2002-08-01 Thread Jas
I need to know the best way to update a record based on something like the session id being the same, except the other fields are not. Any examples of this would help... $table = cm_sessions; $sql_insert_form = INSERT INTO $table (session,ipaddy,host,referrer,hck,nrml,hour,date_stamp) VALUES

[PHP-DB] Re: Multiple select ?

2002-08-01 Thread Adam Royle
Try using parentheses inside your sql: Select * from table_name where (col1=1 OR col2=1) and col3=0 Select * from table_name where col1=1 OR (col2=1 and col3=0) They make a big difference, also helps to indentify what you're selecting when you come back to the sql later. Adam

[PHP-DB] Problem

2002-08-01 Thread Dennis Jacobsen
I have a 2 problems, I need to track referrer urls with a: PROBLEM #1 With HTML Extension http://www.anydomain.com/main.htmll? http://www.anydomain.com/main.htmll?Aid=44554 Aid=44554 1. From an html page I used a similar url http://www.anydomain.com/main.html?

Re: [PHP-DB] Help Needed

2002-08-01 Thread leo g. divinagracia iii
you need a second REQUIRED parameter: mysql_result (PHP 3, PHP 4 ) mysql_result -- Get result data Description mixed mysql_result ( resource result, int row [, mixed field]) as

[PHP-DB] Addslashes in SQL Statement

2002-08-01 Thread Rich Hutchins
I have been wrestling with this off and on for the past couple days and would really appreciate some help. I have a Guest Book page that collects name, address, e-mail, etc. in a form. I won't post the form code because it's just HTML and it works fine. Besically, the page does one of two

[PHP-DB] [php-objects] RE: [PHP] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

2002-08-01 Thread Martin Clifford
I'm definately interested, even though I'll most likely be in MN at the time. I've never even MET another PHP developer, so I don't know what to expect, but I'd sure love to be updated :o) Martin [EMAIL PROTECTED] 08/01/02 03:21PM Well, the predictions have come true. In San Antonio only

[PHP-DB] RE: [PHP] Re: [PHP-DEV] [CROSS POST] PHP Meetup Texas PHP Users

2002-08-01 Thread Jay Blanchard
Well, the predictions have come true. In San Antonio only four folks signed up for the meetup, and the event was cancelled with no way to get in touch with the other local developers to make a go of it. Out of the 147 cities listed only 15 had enough people for meetup.com to do their thing. A