mysql_fetch_array problem

[erveloso]

Hey!

I'm having trouble imploding a query array! This is the query:

$autores = mysql_query("SELECT d.autor FROM publishing.db_autores d, db_escrito_por de, db_artigos de0 WHERE d.autor_id=de.autor_id AND de.art_id = de0.art_id AND de0.art_id = 8");

while($row = mysql_fetch_array($autores, MYSQL_NUM))

{
$shift = implode (", ", $row);
print $shift;
}

This results: Stephen KingStanley Kubrick

If I test with:

while($row = mysql_fetch_array($autores, MYSQL_NUM))


{
print_r ($row);
}

I get this array:

Array ( [0] => Stephen King ) Array ( [0] => Stanley Kubrick )

They both has associated keys as [0]! I think this is why I cant implode it. Is there any workaround?

Thanks! 🙂

[laserlight]

Each iteration of mysql_fetch_array() fetches a row - you need to join the rows, not fields in a row.

$array = array();
while ($row = mysql_fetch_array($autores, MYSQL_NUM))
{
	$array[] = $row;
}
$shift = implode(", ", $array);
print_r($array);

[devinemke]

while ($row = mysql_fetch_row($autores))
{
	$array[] = $row[0]; 
}
$string = implode(',', $array);

[erveloso]

Thanks, but none of the examples above seems to work. 🙁

I just need to get this result:

Stephen King, Stanley Kubrick

The mysql console returns:

+-------------------+
| autor |
+-------------------+
| Stephen King |
| Stanley Kubrick |
+-------------------+
2 rows in set (0.00 sec)

[erveloso]

Wow! It's resolved!!!

Solution:

$array = array();
while($row = mysql_fetch_array($autores, MYSQL_NUM))

{
$yeah = $row[0];
$array[] = $yeah;
}
$shift = implode (", ", $array);
print $shift;

Thanks for the help!!! 😃