[thelist] PHP writing to a csv file

[Andrew Maynes]

I did produce a tab
delimiting file and the code is already there

here is a bit of the code

//* write the products (or a product) into a buffer, that will be shown later.
*/

		if ($s[0] == "END" && $temp[GROUP] && $temp[NAME] && $temp[UNIT_PRICE] && ($g
== $temp[MD5GROUP] || $p == $temp[MD5NAME])) {

			$number_of_products++;

			if ($p && $p != $temp[MD5NAME]) continue;

			if (!$p && ($number_of_products < $min || $number_of_products > $max))
continue;

			if ($p && !$g) $buffer_topic .= "$temp[NAME]";

			if (!$p && $g && !$product_found) $buffer_topic .= "$temp[GROUP]";

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Martin Kuplens-Ewart
Sent: Monday, April 08, 2002 05:04
To: thelist at lists.evolt.org
Subject: RE: [thelist] PHP writing to a csv file


> I am having problems writing to a csv file does anyone know of a good
tutorial

I just did it by doing it...
...erm, what kind of problem are you having?

If it's an issue with data spilling over into different columns
[probably caused by commata in the data itself], may I suggest using tab
delimiting?

Gets really easy with that.
Eg:

FieldName1	FieldName2	FieldName3
<?
$q = "SELECT * FROM $db.$table";
$qe = mysql_query($q);
while($qr = mysql_fetch_array($qe))
{
?>
<?=$qr[Field1]?>	<?=$qr[Field2]?>	<?=$qr[Field3]?>

<?
}
?>

Replace the field name stuff with the names of fields [if you want a key
included], and the query result field names too...

-m


--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/02

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/02