shai1

I found this tutorial on Apple's website and it's been very helpful. Thought I'd share it for other users... http://developer.apple.com/internet/opensource/php.html Thanks again for the help!

I appreciate the help with this. I'll have to do some more research on updating my install. Thanks for the help.

thorpe...I think you've nailed my problem. I looked at the link you supplied, but I'm not sure how I recompile the install with that option enabled. I'm working on OS X and was using the built in install of PHP. Do I need to download the binaries and reinstall it?

I'm trying to do some date math and wanted to use the gregoriantojd function. In the PHP manual, it lists this function as being available for PHP4, PHP 5. I'm running PHP 5.2.5 and I get an error message when i call this function. Fatal error: Call to undefined function GregorianToJD(). Any thoughts on what I might be doing wrong?

I forgot to mention that I had also increased the size of the post_max_size as well when I increased the upload_max_filesize. Both are showing the updates when I load phpinfo().

Yeah, I did load the phpinfo() and it does appear in there with my new size, but the file still fails when i try and upload.

Is there a true cap to the max size of a file upload? I have a file that is just a shade over 15M and I have changed the upload_max_filesize statement in my php.ini file from 15M to 20M, after a restart of my webserver, I still have problem getting the file to upload. There is no specific error message being returned, but the file never makes it to the upload directory. I'm wondering if 15M is the largest file php will ever support regardless of the setting being larger then that? I've uploaded many other files with no issue, the only thing I can figure is the 15M+ size of the file. Any insight to my issue would be wonderful! Thanks, Dave

I want to use the MySQL LOAD INFILE statement to load in external data from an Excel file. The problem I'm having is that not all fields are ENCLOSED by quotes, but many are. Here is the code I'm using... [code]LOAD DATA LOCAL INFILE '/Path/to/File' INTO TABLE working_load FIELDS TERMINATED BY ','  ENCLOSED BY '\"' LINES TERMINATED BY '\r'[/code] What is the proper way to handle a file that will have some fields enclosed by a character, but not all? Or, is there a way I can get Excel to enclose all fields with quotes? Thanks in advance, Dave

I found what I was looking for... [b]Load data infile[/b]. I thought I would post it for others to learn from. When searching I was looking for [b]insert from file[/b] and that is why I couldn't find any information on it. I have not tried it yet, but I've read that it is very fast. Thanks, Dave

A while back I thought I read of a way to insert records from an external file without having to "loop" through them. I've been looking for how to do this and of course now I can't find it again. If anyone could show me an example of how to do this I would really appreciate it. Thanks, Dave

I've contacted my hosting provider and they told me they can't help me because it is a scripting question and they don't support that. The good news is, when I send the same message to a hotmail account or other email accounts I don't see the "sent on behalf" of message. It seems to be something Outlook is doing. Any other thoughts or ideas would be apprecieated. Thanks, Dave

I just purchased hosting from godaddy and am working on a site. When I sent email via mail() with my the header including [b]From: Me <me@mydomain.com>[/b] When I get the email sent via this page in outlook it gives me a long email address and then says [b]sent on behalf of me@mydomain.com[/b] Is there anyway I can make it just say [b]From me@mydomain.com[/b] instead of on behalf of and not show the other email address? Thanks, Dave

This is EXACTLY what I was looking for. Thanks so much! I love internet forums! [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] [!--quoteo(post=389377:date=Jun 29 2006, 01:26 PM:name=jworisek)--][div class=\'quotetop\']QUOTE(jworisek @ Jun 29 2006, 01:26 PM) [snapback]389377[/snapback][/div][div class=\'quotemain\'][!--quotec--] try this... [code] SELECT * FROM table_name WHERE LENGTH(column_name)<=30; [/code] [/quote]

Is there a way I can do a select that will return the records with a character count less then a specific number? i.e. select * from table where character count of textField<=30

My problem now has more to do with the stripslashes function rather than addslashes. When I try and display the data back into the input field I get anything after the ' cut off because that is the character that encloses the data to be displayed. What do I do to solve this problem? Thanks, Dave