I need some quick help with php code

[hyper]

this is for a mainstream site of mine
i could spend 3 weeks trying to figure this out.. but

i need to select data from a mysql table by date then output it
in a comma delimited txt file to download
so i can upload it into paypal for my affiliates.

can someone throw me some generic code

[com]

www.phpbuilder.com
Or use the PEAR API or hire me for 5 minutes ;)

[LuSiD]

Originally posted by hyper
this is for a mainstream site of mine
i could spend 3 weeks trying to figure this out.. but

i need to select data from a mysql table by date then output it
in a comma delimited txt file to download
so i can upload it into paypal for my affiliates.

can someone throw me some generic code

Well, I might need some more details than that, but this is what I would do...

<?php
define("CONN", mysql_connect("localhost", "username", "password");
mysql_select_db("my_db", CONN);

$sql = sprintf("select * from my_table order by my_date");
$result = mysql_query($sql, CONN);
if (mysql_num_rows($result) > 0) {
$str = "";
$fp = fopen("/path/to/file.txt", "w");
while ($row = mysql_fetch_array($result)) {
fputs($fp, implode(',' $row) . "\n");
}
fclose($fp);
}
?>

Hope it helps. Need any more help, hit me up on ICQ. 132514337.

[hyper]

Lusid thanks alot.. i'll give it a whirl later on today