mysql query result into php array

Question

Some code here  I want store mysql query result into an array with php  but my code return result  2h  not what I wish  the correct result should be 36 35 34 33 32     lt  php set time limit 59   mysql select db  mycoon   db   mysql query  SET NAMES utf8      result   mysql query  SELECT id link FROM mytable Order By id DESC LIMIT 0 5     new array      row  while   row   mysql fetch array  result          new array  row  id       row       new array  row  link       row    mysql close  db     close mysql then do other job with set time limit 59  foreach  new array as  array       echo  array  id     lt br   gt        echo  array  link     lt br   gt        gt    Result   36 http   localhost img img36 jpg 36 http   localhost img img36 jpg 35 http   localhost img img35 jpg 35 http   localhost img img35 jpg 34 http   localhost img img34 jpg 34 http   localhost img img34 jpg 33 http   localhost img img33 jpg 33 http   localhost img img33 jpg 32 http   localhost img img32 jpg 32 http   localhost img img32 jpg

User · Answer

Use mysql fetch assoc instead of mysql fetch array  http   php net manual en function mysql-fetch-assoc php

User · Answer

What about this   while   row   mysql fetch array  result           new array  row  id     id      row  id         new array  row  id     link      row  link        To retrieve link and id    foreach  new array as  array              echo  array  id     lt br   gt       echo  array  link     lt br   gt

User · Answer

I think you wanted to do this   while   row   mysql fetch assoc   result         new array      row     Inside while loop     Or maybe store id as key too    new array   row  id       row    Using the second ways you would be able to address rows directly by their id  such as   new array  5

[php] mysql query result into php array

Examples related to php

Examples related to mysql

Examples related to arrays