Fill an array using a mysql database

[Jacek]

I'm trying to code a php page to generate a pdf. In this pdf I would like to have a table with products in: I have a request in the mysql database.

    1. $ commands_products = mysql_query ('SELECT * FROM WHERE lcg_shop_commands_products (id_command = 189)');
    2. $ data = mysql_fetch_array ($ commands_products)

I get a array.

and I would put it in another table

    1. $contentTable = array ($data ['name'], $data ['reference'], $data ['quantity'], $data ['price'], $data ['name'], $data ['reference'], $data ['quantity'], $data ['price'], etc. ...,);

As if I bum a listing of products with the id_command = 189.

but the problem is that I do not know how it finished. Have you any idea?

[switchblade327]

You can do this:

$query = mysql_query($sql);
$contentTable = array();
while($contentTable[] = mysql_fetch_assoc($query)) ;
// View
foreach($contentTable as $row) {
foreach($row as $key => $value) {
echo "$key => $value<br />"
}
}

[Jacek]

The code does not work, the display returns nothing, there was already one; on command echo.

I check my mysql command works fine.

[switchblade327]

Put a print_r ($contentTable) after the while loop