[PHP-WIN] Error 500 in IIS weblog

2005-02-28 Thread Menashe
Hi, I'm running php 5.03 on windows 2003 as isapi. Everything looks OK, and i can see all the php pages, but when I checked the IIS log file I saw that all the requests to php pages are with the error 500. Does someone had this problem ? How can i fix it, i tried to change all the parameters i k

[PHP-WIN] Problem with mail() and attachment

2005-02-28 Thread Stefan Sturm
Hi, I'm using the script below to send ascii files attached to mails via mail(). I'm running the script on different servers and it works fine. Now I got a problem on windows server 2003. The attachment of the mail is disturbed, the first 76 characters are missing, the rest of the attachment is co

[PHP-WIN] problem with mail() and attachment

2005-02-28 Thread Stefan Sturm
Hi, I'm using the script below to send ascii files attached to mails via mail(). I'm running the script on different servers and it works fine. Now I got a problem on windows server 2003. The attachment of the mail is disturbed, the first 76 characters are missing, the rest of the attachment is co

Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread graeme
To reiterate what others have said avoid user input as your primary key, an auto increment would be better. But to get back to your validation problem, you might want to look up the strtotime() function graeme. S.D.Price wrote: Thanks for this George. I am populating the datetime field from use

Re: [PHP-WIN] Re: [PHP] Not able to add data to a MySQL database

2005-02-28 Thread Armando
Try removing the apostrophes around the field names that you are trying to insert data into: $query="insert into login (uname,access) values('try','super')"; Armando Richard Lynch wrote: Vaibhav Sibal wrote: Hi, I am not able to insert data into my mysql database using php even if i use a simple

[PHP-WIN] Re: [PHP] Not able to add data to a MySQL database

2005-02-28 Thread Richard Lynch
Vaibhav Sibal wrote: > Hi, > I am not able to insert data into my mysql database using php even if > i use a simple code as follows : > $link=mysql_connect("localhost","username","password"); > mysql_select_db("test_db"); > $query="INSERT INTO 'login' ('uname','access') VALUES ('try','super')"; >

Re: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Randy Clamons
Just a thought... Using a primary key that is controlled by the user rather than your db system is risky, especially if the user can change the value after adding the record. Why not use an auto_increment field as your primary key and an indexed datetime column to list rows in the order you wish

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread Mike
I know that your form currently has just an input field that displays the date in the format that you're interested in, but have you thought of using a form SELECT object so that the user can only pull down the month, date and year? You'd have to do more processing in the form to "assemble" the da

RE: [PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread S.D.Price
Thanks for this George. I am populating the datetime field from user input, and users can change the date if they need to. The problem I have is with validation. I think I will need to use some kind of regular expression to check that the date has been entered in the correct format, but I am not s

[PHP-WIN] Validation of Primary Key Datetime variable

2005-02-28 Thread S.D.Price
Hi, I wonder if anyone can help. I have designed a newsblog which uses PHP and MySQL. Each news story has a primary key which is the current date. The datatype used in MySQL is "datetime". When stories are extracted from the database the user can then navigate based on date order. When a user ad