from a database to a file???

kc1

Help needed please...... I to retrieve data from my database( name metrep ) and writhe the contenets( its only 1 field at the moment with a string ) and write the contenets to a file, I can hard code a string into php and add this string to a file but i want to write whatevers in my database to the file. pLease help
K

bernouli

$string ="";
$data = mysql_query("SELECT * FROM metrep");
$datarows = mysql_num_rows($data);
if($datarows > 0)
while($entries = mysql_fetch_array($data)) {
   $string .= $entries['your_table_name'];
}

I can hard code a string into php and add this string to a file

now you have $string, which contains all data from your database, now add this $string to the file

AlexP



$string ="";
$data = mysql_query("SELECT * FROM metrep");
$datarows = mysql_num_rows($data);
if($datarows > 0)
while($entries = mysql_fetch_array($data)) {
   $string .= $entries['your_table_name'];
}

Then you can write the data on a file using

$fp = fopen('myfile.txt','w');
fwrite($fp, implode('\n',$string));
fclose($fp);

Simple???

Just experiment around.