reading data from DB

[Anon]

hi,
how can i read data from db table and write
it to txt file.

replay soon..plz

[Anon]

I don't think it's necessary to tell people to reply soon.

Anyway, you read from a db table using

$conn = mysql_connect($server, $user, $pass);
$db = "dbname";
$query = "SELECT column FROM table";
$result = mysql_db_query($db,$query ,$conn);

$fp = fopen("filename", "a");

while($myrow = mysql_fetch_array($result))
{
$column = $myrow["column"];
$writefile = fputs($fp, $column);
}

fclose($fp);

You can customize the code for your specific needs.

Richard Akindele

geocities.com/akindele/

[Anon]

thank u ...
but the data written in one line inside that
txt file !!??
how can i write each field value in a different new line..
see the full picture is :
i have two fields
i want to display two fields values beside each others and separated with | like this:
field1's value1|field2's value1

field1's value2|field2's value2 in txt file