Re: array help

Did you bother to initialize $table as an array() or are you another lazy slob of a programmer that expects the engine to read your mind (cluttered as that may be)? Cheers, Rob. On Thu, 2005-07-14 at 18:33, Fletcher Mattox wrote: > How does one represent a MySQL table as a two dimensional array > using the column names as one of the indices? My naive attempt > went something like this: > > while ($row = mysqli_fetch_assoc($result)) > $table[] = $row; > > but that generated this error; > > Fatal error: [] operator not supported for strings > > Ok. So then I try to explicitly assign each row, like this: > > while ($row = mysqli_fetch_assoc($result)) > $table[$i++] = $row; > > While that generates no error, $table contains nothing useful when > I'm done. So then I try to assign each row and column, like this: > > while ($row = mysqli_fetch_assoc($result)) { > foreach ( $row as $col => $val) > $table[$i][$col] = $val; > $i++; > } > > And that got me this error: > > Fatal error: Cannot use string offset as an array > > So clearly my understanding of PHP arrays is lacking. > Please help. > > Thanks > Fletcher -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------'