Problem writing CSV file. Duplicates...

victorysshadow

When I write a file using the following code:

while ($record_set_array =  mysql_fetch_array($result_set, MYSQL_BOTH)) { 
  fwrite($fp, implode(",", $record_set_array) . "\n");
}

I get the following in my file:

2004-12-03,2004-12-03,22 days 'til Christmas!,22 days 'til Christmas!,BRENT,BRENT,Red,Red

Notice that every row from each column is recorded twice... anyone see why?

Thanks.

tsinka

Hi,

the reason is MYSQL_BOTH. That causes PHP to return an array containing the data twice so you can access the data by a numeric key and additionally by the column name.

Use

while ($record_set_array = mysql_fetch_row($result_set)) {

Thomas

victorysshadow

sweet. thanks. I have two more questions, maybe you can help.

is there a way to:

A) get the column names to be added as the first record?
😎 list all the tables in a database through an SQL query... like SELECT * FROM database??

Thanks.

tsinka

a) use mysql_fetch_assoc instead of mysql_fetch_row and then array_keys (once) to get the column names of the fields fetched by the query. Or execute the quiery
show columns from thetable to get the real column names if you used aliases in the sql query.
b) show tables [from dbname]
without the from part that query shows the tables from the currently selected db (mysql_select_db).