I wish I knew more about multi-dimensional arrays
| From: | Verdon vaillancourt | Date: | Fri, 22 Aug 2003 16:37:30 +0000 |
| Subject: | I wish I knew more about multi-dimensional arrays | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-160427@lists.php.net to get a copy of this message | ||
Hi, please don't chuckle (too loudly) at my attempts to learn ;)
I'm trying to create what I think would be a multi-dimensional array from a
mysql result set, to use in some example code I got off this list last week.
The example renedring code I want to work with is...
<?php
$data = array('A', 'B', 'C', 'D', 'E',
'F', 'G');
$rowlength = 3;
echo ("<table>");
for ($i = 0; $i < sizeof ($data); $i += $rowlength)
{
echo ("<tr>");
for ($j = 0; $j < $rowlength; $j++)
{
if (isset ($data[$i+$j]))
{
echo ("<td>{$data[$i+$j]}</td>");
} else {
echo ("<td> </td>");
}
}
echo ("</tr>");
}
echo ("</table>");
?>
I trying to create the $data array from my query results like this...
$sql = "select * from table limit 0,5";
$result = mysql_query ($sql);
$number = mysql_numrows ($result);
for ($x = 0; $x < sizeof (mysql_fetch_array($result)); $x ++) {
$data = implode (',',$result[$x]);
}
I had hoped this would get me the six arrays on the page (where I could then
extract the values). I've also tried a number of similar approaches but am
consistently getting six error messages on the page along the lines of
Warning : implode() [ function.implode ]: Bad arguments. in
I know I'm missing something basic and would appreciate any pointers.
Thanks,
Verdon