php - Array not containing both values from query -


i trying array contain 2 values; skillid , description. when print value of array showing description. how can array show both??

$skillresult = $con->query("select userskills.`skillid`, `description`, `experience` `user` inner join `userskills` on user.`userid` = userskills.`userid` left outer join `skills` on userskills.`skillid` = skills.`skillid` user.`userid` ='$user'")      or die(mysqli_error($con));      $skills_array = array();      while($r=mysqli_fetch_array($skillresult))     {     if (!isset($skills_array[$r['skillid']]))     {         $skills_array[$r['skillid']] = array();     }     $skills_array[$r['skillid']][] = $r['description']; } 

print output:

array ( [0] => array ( [0] => java ) [1] => array ( [0] => unix ) ) 

description 'java' should have skillid of '1' , unix '6'.

is $skills_array array supposed 2-dimensional?
isn't want?

array ( 1 => java, 6 => unix) 

in case, work:

while($r=mysqli_fetch_array($skillresult)) {     $skills_array[$r['skillid']] = $r['description']; } 

Comments

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

python - GRASS parser() error -

Swift game error message -