Re: [PHP] MySQL vs. basic text file

2002-09-23 Thread Justin French
Hi Doug, on 22/09/02 9:25 AM, Doug Parker ([EMAIL PROTECTED]) wrote: > often i use text files at my data sources, delimted by the "|" symbol. > i simply delimit the fields of each line, then when i need to open them, > i open the text file, populate an array with each line, then explode the > fi

[PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread Chuck \"PUP\" Payne
Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry

[PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread Chuck PUP Payne
Ok, Let's try this again, for some reason this didn't post from early today. I have db that has two tables that I am needing to post the same information into both tables, I can't use ID. So I am want to see if there is a sql statement that will let me or how I can do with a php page. I am sorry

[PHP] Re: PHP.exe crash Problem

2002-09-23 Thread simanhew
The interesting thing is that we has the same page on Solaris, it works fine. I will send the code in another email. Thanks very much, Siman <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > We need to see the page. > > -- > > Nicos - CHAILLAN Nicolas > [EMAIL

RE: [PHP] Encryption Question

2002-09-23 Thread Mark Charette
Just how are you going to decrypt it? Password encryption is ordinarily one-way - you have no choice. You have to compare encrypted passwords. -Original Message- From: Tom Ray [mailto:[EMAIL PROTECTED]] SI want to compare a password to a encrypted password stored in my mySQL database usin

Re: [PHP] How do i assign Integers only and not real numbers?

2002-09-23 Thread Justin French
Wouldn't round() work??? Or, if you always want to round down, why not just split it on the decimal? Or as long as you're willing to give up year 10,000 compliance :), the year will "always" be the first four digits. Plenty of options :) I think I'd just use substr() Justin on 24/0

Re: [PHP] Mail problem with more than 1k users

2002-09-23 Thread Justin French
This gets discussed quite frequently. My guess is that your ISP *may* be imposing some limitations, but more likely your PHP script is timing out or something similar. Justin on 24/09/02 9:08 AM, Research and Development ([EMAIL PROTECTED]) wrote: > Hello. I wrote a PHP script that will pull

[PHP] SQL : left join from multiple tables

2002-09-23 Thread Faisal Abdullah
Hi again people! How's it goin? Here's the question How do I do left joins from multiple tables? I want to do something like this: "select a.name, b.department, c.position from emp a left join dept b on a.staffno = b.staffno left join position c on a.staffno = c.staffno where staffno = $staffno"

Re: [PHP] Mail problem with more than 1k users

2002-09-23 Thread Philip J. Newman
I suggest you get a mailing list program if your sending to more than 1k of users Philip - Original Message - From: "Justin French" <[EMAIL PROTECTED]> To: "Research and Development" <[EMAIL PROTECTED]>; "PHP General List" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 1:57 PM Sub

Re: [PHP] Another Encryption question

2002-09-23 Thread Tom Ray
also if I comment out $iv, I get the error "Call to undefined function mcrypt_encrypt()" on that line.. I just don't understand why it keeps doing this. I'm running 4.2.2 Tom Ray wrote: > I dipped into mcrypt about a month or so, and did this script back > then. I had it working, it would k

RE: [PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread John Holmes
Just run two inserts. You can't do it with just one. I'd have to guess you have design issues if you have to do this anyhow... ---John Holmes... > -Original Message- > From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 9:45 PM > To: PHP General > Subje

RE: [PHP] Another Encryption question

2002-09-23 Thread John Holmes
Look at a phpinfo() page, do you have mcrypt installed? I'd have to guess no, because that's generally how you get this error. ---John Holmes... > -Original Message- > From: Tom Ray [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 10:15 PM > To: [EMAIL PROTECTED] > Subject:

RE: [PHP] Crypt() =or= md5()

2002-09-23 Thread John Holmes
I couldn't find anything in the manual, but I don't think crypt() works in windows...or at least 95/98. Or the function may be denied in your PHP.ini for some reason. ---John Holmes... > -Original Message- > From: Anthony Ritter [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 20

[PHP] session and expiration function

2002-09-23 Thread christian haines
hi, is it possible to have a function execute when a session expires using php4 sessions? i know how to execute a function if i control the timeout (as mentioned elsewhere in this group) but what about if the session times out itself using the inbuilt garbage collection routine. if so, any ideas

RE: [PHP] session and expiration function

2002-09-23 Thread John Holmes
> is it possible to have a function execute when a session expires using > php4 > sessions? > i know how to execute a function if i control the timeout (as mentioned > elsewhere in this group) but what about if the session times out itself > using the inbuilt garbage collection routine. > if so, a

[PHP] Re: Maybe a stupid question but can it be done?

2002-09-23 Thread Remon Redika
I just run two insert to do that. with two different sql syntax ... Chuck PUP Payne writes: > Ok, Let's try this again, for some reason this didn't post from early today. > > I have db that has two tables that I am needing to post the same information > into both tables, I can't use ID. S

Re: [PHP] session and expiration function

2002-09-23 Thread christian haines
thanks john, hmmm... i suspected as much... i guess the way to do it would be to set a highly improbable garbage collection and long timeout via ini_set. then use a timeout function attached to the session which launches on expiration cheers christian "John Holmes" <[EMAIL PROTECTED]> wrote in

RE: [PHP] session and expiration function

2002-09-23 Thread John Holmes
Just use ini_set() to set a different session.save_path() than what's in your PHP.ini. then the garbage collector won't touch it. Write your own script to do the deleting and call whatever functions you need. Add that to your cron script to run every hour or day, and you're good to go. You made yo

Re: [PHP] session and expiration function

2002-09-23 Thread christian haines
thanks.. i will check it out "John Holmes" <[EMAIL PROTECTED]> wrote in message 002601c26378$b4189350$b402a8c0@mango">news:002601c26378$b4189350$b402a8c0@mango... > Just use ini_set() to set a different session.save_path() than what's in > your PHP.ini. then the garbage collector won't touch it.

[PHP] Small PHP project - will pay!

2002-09-23 Thread Paul
I have a small PHP project that currently needs to be built based on Microsoft MSDE database (already in place) and later on perhaps move it to MySQL.. If interested please contact me [EMAIL PROTECTED] Thanks Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:

Re: [PHP] Frusration using Sessions!!!

2002-09-23 Thread Chris Shiflett
Don, First I must strongly advise that you never, ever design a Web application that depends on the back button. This is a key characteristic of a poorly designed application in most cases and is worth a second look. Glancing at the HTTP headers you are sending, two things stand out to me. F

[PHP] Re: Mail problem with more than 1k users

2002-09-23 Thread Manuel Lemos
Hello, On 09/23/2002 08:08 PM, Research And Development wrote: > Hello. I wrote a PHP script that will pull records from a database > (emails) and then mail something to the emails in the result set. Pretty > simple and it worked. > > Now that the database has over 1 thousand records I began t

RE: [PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread Peter Houchin
if the 2 tables have the same name can't he just go INSERT INTO table1, table2 (table1.name=$name, table2.name=$name ... blah); think u can do that .. but again that relies on table names being the same i guess... > -Original Message- > From: John Holmes [mailto:[EMAIL PROTECTED]] > Sen

[PHP] MAil and mysql help

2002-09-23 Thread D4rks1d3
hi i need to put a mysql_query into an email, best explained.. while ($row=mysql_fetch_rows($base)) //$base=MySQL Query echo "\n"; echo "$row[0]\n"; echo "$row[1]\n"; echo "$row[2]\n"; echo "$row[3]\n"; well. the result is a table with users an information about them.. i want to sent this table

Re: [PHP] Re: Mail problem with more than 1k users

2002-09-23 Thread Peter J. Schoenster
> On 09/23/2002 08:08 PM, Research And Development wrote: > > So I re-designed the script to send emails in parts. 500 emails per > > header. But after the database reached more than 3,000 records the > > emailing did not work at all. Sendmail refused to send to any of the > > emails in the data

RE: [PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread Peter Houchin
opps same fields even sawwy :) > -Original Message- > From: Peter Houchin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 24 September 2002 1:49 PM > To: 'PHP General' > Subject: RE: [PHP] Maybe a stupid question but can it be done? > > > if the 2 tables have the same name can't he just go >

RE: [PHP] Maybe a stupid question but can it be done?

2002-09-23 Thread John Holmes
> if the 2 tables have the same name can't he just go > > INSERT INTO table1, table2 (table1.name=$name, table2.name=$name ... > blah); > > think u can do that .. but again that relies on table names being the same > i > guess... No...That's not a valid query. ---John Holmes... -- PHP Gener

Re: [PHP] Mail problem with more than 1k users

2002-09-23 Thread Peter Janett
I started dealing with this several years ago using Perl. The closest I got with sendmail was to check that the call worked, and if it didn't try again up to 5 times. For me, bottom line, if you want to do what you are trying to do, use something besides sendmail. I switched to Qmail, and have

[PHP] file uploads problem

2002-09-23 Thread Jaski
Hi, (Linux RH 7.1, Apache/1.3.22, PHP 4.0.6). I am trying to write a script to send emails. It needs to support attachments. The point where I am stuck is after the file to be attached gets uploaded to /tmp as /tmp/tempfilename thorough an HTTP POST form. I am not able to open that file direc

Re: [PHP] Re: Mail problem with more than 1k users

2002-09-23 Thread Justin French
on 24/09/02 2:12 PM, Peter J. Schoenster ([EMAIL PROTECTED]) wrote: > Eeks. I hate that. I hate email that does not indicate it knows who > I am. Why is sending one email to one user so bad? I can't think of a > reason that would trump the personalization that I like so much. But > I'm all ea

Re: [PHP] file uploads problem

2002-09-23 Thread Oscar F
Try: $upload = "/path/to/copy/"; $upload_path = "$upload/$file_filename"; if (is_uploaded_file($file)) { Exec("cp $filename $upload_path"); } Then you have the file at /path/to/copy/, and you can do whatever you want with it. (I'm assuming the file field of the form is called "file", and that

Re: [PHP] Re: session & cookies

2002-09-23 Thread Jeff Bluemel
ok - no cookie exists... I have Netscape set to accept all cookies. I'm wondering if it is in my link, or if it is a configuration error somewhere. here is a copy of the session options from my php.ini (as copied from Zend Server Center) Session data handler files Session save path/tmp Use cook

Re: Re: [PHP] file uploads problem

2002-09-23 Thread Jaski
Thanks .. but I think you are saying exactly what I wrote I was doing .. except that you have used exec("cp $file $path") while I tried PHP's copy() function .. I don't think that will make a difference...though will give that a try any way. Forgot to mention in my previous mail that the dire

Re: [PHP] Re: session & cookies

2002-09-23 Thread Chris Shiflett
Jeff, One quick thought ... Is your cookie domain the same domain as the URL domain you are using to test this? If not, the browser will not send the cookie, so that is a potential reason for this behavior. If the domain is the same, I see no reason why this shouldn't work, but I have two id

Re: [PHP] file uploads problem

2002-09-23 Thread @ Edwin
Just a comment... On Tuesday, September 24, 2002 1:39 PM Jaski wrote: > I tried to copy this file using > move_uploaded_file($userfile, "/place/to/put/uploaded/file"); > > and here a strange thing happened. The file was successfully > copied BUT it had permissions like -rw-- which I interpret

<    1   2