Calling Data from Txt Files

Helios

My mySQL database often has "Too many connections" errors because it is shared on a server with about thirty people and many of them have (and some doubly) installed phpNuke, which heavily uses these. So my database has about as much as it can have on it right now, which leads me to my question:

How can I call different bits of info from a text file? For instance, here is an example text file:

Then I would like a PHP news script to put this all onto a page, where it would have a header cell in a table say "News for 11.12.2002, Posted by: Helios" and then below that it would have my update, "Didnt update much today, just trying to get a script debugged" then it would have another table with the header cell saying the date 11.13.2002, Posted by: Jeff, and then his message, etc. This does not have to be verbatim like that I just want to know how to seperate different pieces of info into different arrays. I know XMB forums do this with their template.xmb file. An piece of example code is great, I just need to know very basically how to do it, I don't need that code above. Thanks in advance,

Helios

barand

$array = explode("|",$newstxt) will separate all the fields in to array items.

If you redesign your text file so each news item ends with a newline then life becomes even easier.

$newsarray = file("news.text")

will give an array where each item is a line from the file. You can the proccess the array exploding each line into its 3 fields with

list($date,$name,$message) = explode("|",$newsarray[$i];

Check out [man]explode[/man], [man]file[/man], [man]list[/man]

Helios

Thanks a lot, that is very helpful, but how to I output the data? I know how to put HTML around it and everything but I know little to nothing about PHP, other than simple functions to define variables, etc. I have had very little about object oriented PHP programming and if anyone could help me out that would be great. Again, thanks

Helios