Fill an array using a mysql database
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.
Code:
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
Code:
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?
Re: Fill an array using a mysql database
You can do this:
Code:
$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 />"
}
}
Re: Fill an array using a mysql database
The code does not work, the display returns nothing, there was already one; on command echo.
I check my mysql command works fine.
Re: Fill an array using a mysql database
Put a print_r ($contentTable) after the while loop