BrotherLogic

PROBLEM: I am currently outputting names to a .txt file.  The problem is that when I open up the text file the names are displayed like this: Jonny Miller<newline>Charlie Babbot<newline>ChewY Hansolo........ I need the names displayed like this: Jonny Miller Charlie Babbot Chewy Nasalund When I use the fgets() it picks up a bunch of names............................ how can I get this text file to save in a format which recognizes newline characters........??????

I need to know if this is possible. I am looking to convert MS Office files to .html with PHP... Thanks guys.

Is it possible to create these microsoft documents from PHP? Thanks for your responses!

I am running a programs that creates a bunch of different .txt files.... after every entry in the .txt file I am trying to make a newline... (when I open the .txt file in Notepad the names are all joined together) Wordpad is fine. i.e.: Jon Smith"\r"Joe Murphy"\r"Jerry Garage"\r" (where the "\r" is that vertical triangle character representing newline) I want the output to the fopen file to be: Jon Smith Joe Murphy Jerry Garage What is the directive to do this? Thanks Guys I appreciate it.

Thanks a Bunch Barand... Big Help.

I forgot to add that I am running a windows IIS 6.0 server... Is there a CronTab like solution for Windows Server 2003?

PROBLEM: I am currently writing a PHP program that rips data from a popular site. I am then uploading this data into a MySQL database on my server. The problem is that there is about 200 - 250 page reloads (on this sites server) when the script is activated. I think they are cutting me off at about 25 - 30 page reloads. Needless to say I'm only getting a fraction of the information I need at one time. I have talked to the company and they do not mind me ripping the data as long as it does not backup their servers (completely understandable). SOLUTION: The solution I have come up with is to break the script into 20 - 30 different scripts that rip the data at different times throughout the day. This way there is only 10 page reloads per activivation of the script. Since there is no possible way to activate the script manually 30 times throughout the day to get all of the necessary data. This brings me to my question: QUESTION/FIX: Can a .php script be activated automatically at a precise time that is set on a given day? (i.e. www.yourname.com/update.php will be loaded at 6:30 PM EST, on MON, WED, and FRI)?

:-[ I'm such a dope sometimes!! Thanks Budd.. Really Appreciated.

I need help with some syntax in an INSERT QUERY.   [code]$insertfundquery = "INSERT INTO longterm( fid, fundname, starrating) VALUES ('$fundname', '$starrating')";[/code] Half way through a loop this script comes up in error becuase $fundname = MacKenzie's What is the right syntax to include apostrophes in a string........ Is there a way? Thanks Everyone

Oh yeah. You guys rock. Totally my bad... I was getting syntax errors when I took the quotes out because I had the code in the wrong place in my script from testing. Also... I get this error: Error: Out of range value adjusted for column 'fid' at row 1 with query INSERT INTO longterm( fid, fundname, starrating, firstyear, thirdyear, fifthyear, tenthyear, fifthteenyear) VALUES ('', Exposed Fund, '5Star', '7.04', '11.65','7.82','0','0') ________________ but when I put a zero in for the "fid" VALUE everything works fine. Thanks a Bunch Guys. I really appreciate your help and effort. Jon

@RG -- how should it be arranged? I'm lost, I'm a complete newbyyy. Thanks for your help guys.

Error: Data truncated for column 'firstyear' at row 1 with query INSERT INTO longterm( fundname,starrating, firstyear, thirdyear,fifthyear, tenthyear, fifthteenyear)VALUES ( "$fundname", "$starrating","$firstyear", "$thirdyear", "$fifthyear","$tenthyear", "$fifthteenyear") Error: Data truncated for column 'firstyear' at row 1 with query INSERT INTO longterm( fid, fundname, starrating, firstyear, thirdyear, fifthyear, tenthyear, fifthteenyear) VALUES ("0", "$fundname", "$starrating","$firstyear", "$thirdyear", "$fifthyear","$tenthyear","$fifthteenyear")

I've tried the (5,2) in the definition of the table. Still the same error number and error output.

Still not working. I am getting "data truncated for column 'firstyear' at row 1" from mysql_error and I am getting ERROR #1265 from mysql_errno. Anybody know what the problem might be? Thanks a bunch.

the values are as follows: 7.04 , 1.66, 21.11, 27.35, 0, etc. I am getting the same error with all the values. Thanks for the help everyone. I am a mySQL newbian.