help out a newbie

[Anon]

I have a music website and on the tour dates page, it is a huge hassle to update the tables I have everytime I need to update it with new tour dates.

There are 4 different columns: Band, Date, Location, and Venue.

After that comes all of the data to be listed. I've seen this done with CGI before, but I'd like to get this working with PHP. I do have MySQL on my server, but I'd rather just use a flat text file for storing the information.

Right now I have the file looking like this:
Tool|4/25/01|Nijmegen, NET|Dynamo Open Air

Does anyone have some code I can use to call the data from the text file and put it into the tables automatically? This is a pretty simple thing to do, but I'm still learning how to do this stuff. Any help is appreciated, Thanks.

[craigh]

A benefit of using MySQL is that you could use termination dates. This would automatically delete the record from being displayed after that date and you would not have to manually change it.

read the manual on mysql operations and build the better way. it really isn't that hard.

[cheesehead]

I do the same sort of stuff as I don't have a database.

Here's the basics.

$htmlcode = "";

$fp = fopen( "txtfile.txt", 'r' );
while( ! feof( $fp ) )
{
$dataline = fgets( $fp, 1024 );
$data = explode( '|', $dataline );
$band = data[0];
$date = data[1];
$location = data[2];
$venue = data[3];
$htmlcode .= "<tr><td>$band</td><td>$date</td></tr>etc.."
}

.
.
<table>
<?php print $htmlcode; ?>
</table>
.
.

You can use a counter if you want multiple across the page like http:www.demoncheese.co.uk/guestbook.php which works along the same principles. Let me know if you want the code.