Simple Flat File database help

[sgtpepper]

Hi,

I am trying to create a very simple php script that will:

1. Collect data from a form
2. Place data in a CSV file
3. Display data from the file on a page
4. Replace old data with new data if form is filled in again.

I have the following script:

<?php
@extract($_POST);
if(is_writable('file.csv'))
{
$fp = fopen('file.csv','a');
$content = "$lastname,$firstname,$email,$format,$date\n";
fwrite($fp,$content);
fclose($fp);
}
else
{
echo'File is not writable';
}
?>

This is placing the data in the csv file....however...if I use the form again...it add the new data. I want it to replace the data. Can you help me figure out what I need to tweak in my script?

Also, how do I pull the data out of the csv file?

Thanks

[danyprundus]

Use instead

fopen('file.csv','a'); 

this

fopen('file.csv','w'); 

a- is for append
w is for write

[sgtpepper]

Thanks!

That did the trick.

One last question:

Now that I have my data stored in a csv....what is the proper way to pull the data from the file and display it?

I am used to pulling it my a mysql database and I am confused on what to do next.