mysqli fetch array while loop columns

Question

Should be pretty basic  but I can t get it to work  I have this code to iterate over a mysqli query   while  row   mysqli fetch array  result          posts      row  post id    row  post title    row  content        It works and returns      Variable  1     Array  3 elements           0  String    4testtest   9 characters         1  String    1Hello world Welcome to WordPress  This is your first post  Edit or delete it  then start blogging    99 characters         2  String    2Sample PageThis is an example page  It s different from a blog post because it will stay in one place and will show up in   your site navigation  in most themes     161 characters    The problem is that it puts all three colums into one column  so I can t access them seperatly    This for example       0  String    4testtest   9 characters    Should be seperated into 4  test  test  When I do this   while  row   mysqli fetch array  result                       posts  post id      row  post id         posts  post title      row  post title         posts  type      row  type         posts  author      row  author             It only outputs 1 row instead of all three      Any help is greatly appreciated

User · Answer

Both will works perfectly in mysqli fetch array in while loops  while  row   mysqli fetch array  result MYSQLI BOTH          posts      row  post id    row  post title    row  content         OR   while  row   mysqli fetch array  result MYSQLI ASSOC          posts      row  post id    row  post title    row  content        mysqli fetch array   - has second argument  resulttype   MYSQLI ASSOC  Fetch associative array  MYSQLI NUM  Fetch numeric array  MYSQLI BOTH  Fetch both associative and numeric array

User · Answer

Try this        i   0          while  row   mysqli fetch array  result                     posts  post id      row  i   post id                 posts  post title      row  i   post title                 posts  type      row  i   type                 posts  author      row  i   author                         i           print r  posts

User · Answer

Get all the values from MySQL        post   array        while  row   mysql fetch assoc  result                  posts      row          Then  to get each value    lt  php       foreach   posts as  row                          foreach   row as  element                                echo  element   lt br gt                              gt    To echo the values  Or get each element from the  post variable

User · Answer

Try this     while  row   mysqli fetch array  result  MYSQLI ASSOC

User · Answer

This one was your solution    x   0  while  row   mysqli fetch array  result                       posts  x   post id      row  post id         posts  x   post title      row  post title         posts  x   type      row  type         posts  x   author      row  author         x

User · Answer

I think this would be a more simpler way of outputting your results   Sorry for using my own data should be easy to replace     query    SELECT   FROM category      result   mysqli query  connection   query         while  row   mysqli fetch assoc  result                  cat id    row  cat id             cat title    row  cat title             echo  cat id          cat title     lt br gt            This would output     -ID Title   -1 Gary -2 John -3 Michaels

[php] mysqli_fetch_array while loop columns

Examples related to php

Examples related to mysqli

Examples related to while-loop

Examples related to multiple-columns