[RESOLVED] help sorting array/mysql result?

jasondavis

The below code returns 4 images from 4 users with there user ID's being 22905,2,13,17396,
The problem is instead of showing in this order 22905,2,13,17396 it keeps showing un numeric order from smallest to largest and I need it to show in the order it is saved in teh DB as
so 22905,2,13,17396 is showing up as 2,13,17396,22905 and I really need it as 22905,2,13,17396

<?PHP
// we pull this from DB, I have it here for testing purposes
$line_member['topfriendslist'] = '22905,2,13,17396';

//this returns the value associated with these userid's 22905,2,13,17396
$sql_frienduser = 'select auto_id,disp_name,pic_url from friend_reg_user where status="Active" and auto_id in (' .$line_member['topfriendslist']. ')';
$result_frienduser = executequery($sql_frienduser);

//we have 4 matches above so now we cycyle through them and show there images
for ($_top = 0; $_top < 4; $_top++){

if ($line_frienduser = mysql_fetch_array($result_frienduser)) {
	// build image
	$height = 70;
	$width = 80;
	if($line_frienduser['pic_url'] != ''){
		$img_name = $line_frienduser['pic_url'];
		$file = "uploded_files/userphoto/" . $img_name;
		$fil_ext1 = pathinfo($file);
		$fil_ext = $fil_ext1["extension"];
		$fil_explode = '.' . $fil_ext;
		$arr = explode($fil_explode, $img_name);
		$img_name = $arr[0] . "_thumb1" . $fil_explode;
	}else{
		$img_name = 'nopic.gif';
	}
	echo '<img src="uploded_files/userphoto/' .$img_name. '" border=0>';
} 
}

?>

dagon

you should have a field in the db you can sort on, otherwise pull them all out and loop through $line_member['topfriendslist'], matching them against the results already retrieved from the db

dagon

5 minutes of research latter:
$sql_frienduser = 'select auto_id,disp_name,pic_url from friend_reg_user where status="Active" and auto_id in (' .$line_member['topfriendslist']. ')' ORDER BY FIELD(auto_id,' .$line_member['topfriendslist']. ');

mysql Field function

jasondavis

thanks very much that helps a lot! It's a shame it doesn't sort this way automaticly, in the order you feed them into the query but this doesn't seem to slow things up much

dagon

you really should have a field to sort on

jasondavis

dagon;10922252 wrote:
you really should have a field to sort on

IN this case I don't see how I could, this is pulled from a user table and that filed stores a users top friends, like myspace has, top friends are stored in a comma deliminated list, It can range anywhere from 4-24 different ID's so if I stored these in there own table that could be an extra 24 entries per user, I don't see any other way of doing it unless i'm overlooking it?

dagon

shouldn't be stored in a comma deliminated list, that's bad db design, and hence the problem.