[Rahil]

Hi guys,

I have this very frustrating problem

I'm trying to make a dynamic table with only 3 columns per row. So every 3 items, I need a new row.

This code works fine, in fact, some may benefit from it:

PHP Code:

<?php



echo "<pre>";



$input_array = array('1', '2', '3', '4', '5', '6', '7', '8');

$input_array = array_chunk($input_array, 3, true);



echo "<table width=\"500\" border=\"0\" cellspacing=\"5\" cellpadding=\"0\">\n";



foreach ($input_array as $set) {

    echo "<tr>\n";

    foreach ($set as $key) {

        echo "  <td>$key</td>\n";

    }

    echo "</tr>\n";

}



echo "</table>\n";



echo "</pre>";



?>

Now, here is my problem. The array I created above is static. I want a dynamic array that is created from MySQL values. How can I do that? I can provide more details if needed, I'm just not sure what I need to make this happen.

Is there a MySQL function that will do this for me? mysql_fetch_array only fetches an array for one row in the MySQL table unless I loop it. I was thinking I could use PHP's array appending functions.

Please, I would love any help

[duesi]

I think you can use the push function for this:

PHP Code:

    $sql="SELECT name FROM table"; 

[Rahil]

Thanks for the quick reply.

I looked at array_push but I'm dealing with multi-dimensional arrays. Each product has its relative details (i.e. ID, product name, price, etc.), and array_push is only for appending single values to the end of the array.

Maybe array_merge?

[duesi]

Sorry, i hit the button too quick, my code wasn't finisehd.
OK, If your array is mutlidimensional, array_push will not help.

[UnrealEd]

Originally Posted by Rahil

Is there a MySQL function that will do this for me? mysql_fetch_array only fetches an array for one row in the MySQL table unless I loop it. I was thinking I could use PHP's array appending functions.

as you are going to loop over the array with php array functions, you could just use a while-loop to loop over the entries mysql returned:

PHP Code:

echo "<table border=\"1\">\n";

$res = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_row($res)){

  echo "<tr>\n";

  foreach($row as $key => $value) echo "<td>$value</td>\n";

  echo "</tr>\n";

}

echo "</table>"; 

Greetz,
UnrealEd