Hi,
I'm trying to combine and sort two tables so I can display the output as one. And I'm getting the error "PHP Warning: array_multisort() [<a href='function.array-multisort'>function.array-multisort</a>]: Array sizes are inconsistent in ... on line 282". Line 282 is "array_multisort($tmp_name, SORT_ASC, $details);". I'm a self taught beginner coder and I know that my coding is often very clumsy and so that is probably the problem. Any help to solve this error would be greatly appreciated. Cheers
$sql = "SELECT * FROM db_user LEFT JOIN db_details ON db_details.details_id = db_user.user_details_id WHERE db_user.user_id = '" . $user_id . "'";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ($num != NULL) {
for ($i = 0; $i < $num; $i++) {
$user_group_id = mysql_result($result, $i, "db_user.user_group_id");
$details_id = mysql_result($result, $i, "db_details.details_id");
$details_name = mysql_result($result, $i, "db_details.details_name");
$details[] = array($details_id, $details_name, $user_group_id);
}
}
$sql = "SELECT * FROM db_members LEFT JOIN db_details ON db_details.details_id = db_members.members_details_id WHERE db_members.members_user_id = '" . $user_id . "'";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ($num != NULL) {
for ($i = 0; $i < $num; $i++) {
$members_group_id = mysql_result($result, $i, "db_members.members_group_id");
$details_id = mysql_result($result, $i, "db_details.details_id");
$details_name = mysql_result($result, $i, "db_details.details_name");
$details[] = array($details_id, $details_name, $members_group_id);
}
}
foreach ($details as $key => $val) {
$tmp_name[$key] = $val[1];
}
array_multisort($tmp_name, SORT_ASC, $details);