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
Post a Comment