implode() and mysql_fetch_array()

[addamb]

Hi all,

I guess I don't understand either the implode() function or the mysql_fetch_array() function properly... because the code below returns the query results ok, just with each column duplicated.

-eg. for a table:

col1 col2
addam 10 smith st
john 20 simpson lane

it returns

addam addam 10 smith st 10 smith st
john john 20 simpson lane 20 simpson lane

how can i remove the duplicate columns?

<CODE>
$connection = mysql_connect($server, $user, $pass);

$result=mysql_db_query($db, $query, $connection);

echo ("<TABLE>");
while($row=mysql_fetch_array($result))
{
$x='<TD>' . implode("</TD>\n<TD>", $row);
echo "<TR>" . $x . "</TR>\n";
}
echo ("</TABLE>\n");
}
</CODE>

[snoopy71]

Hi Addam,

I've just gone though this myself. The problem is with

mysql_fetch_array()

If you use

mysql_fetch_row()

it will solve the problem with the duplication. don't ask me why exactly, i've been scracthing my head about it too.

if anyone out there could please explain it to me, please do.

later
Sam

[Anon]

I think this is because mysql_fetch_array returns each value with 2 keys. One key is an integer, the other is the name of the database column.

From the PHP documentation:

The optional second argument result_type in mysql_fetch_array() is a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. (This feature was added in PHP 3.0.7)

If you use MYSQL_NUM or MYSQL_ASSOC in the second argument, it should get rid of the duplication.