reverse the order of array and limit number?

jasondavis

Code below gives me a list of ID numbers, is there a way to reverse the order they are shown in?

<?
$sql="SELECT used_id FROM friend_vote WHERE id='$info[auto_id]'";
$result_user=executeQuery($sql);
$line_user=mysql_fetch_array($result_user);

if($line_user[used_id]!=''){
   $temp_friendids_arr=explode(",",$line_user[used_id], 10);
} 

$no=1;
	  if(is_array($temp_friendids_arr)){
	  foreach($temp_friendids_arr as  $ind=>$val){
?>

NogDog

You mean like [man]array_reverse/man?

jasondavis

Im having a lot of trouble Im trying to show 4 images wide per row the result of my array in reverse order but no matter what I try, it wont sort in the right order

can someone help please

<table width="100%" border="0" cellspacing="8" cellpadding="0" class="maintable">
<tr>
    <td class="member20" colspan="4">Last 24 People to Rate Me - Most recent rates 
      are listed first</td>
</tr>
<?
$back=urlencode(geturl());
validlogin($back);

$sql="SELECT used_id FROM friend_vote WHERE id='$info[auto_id]'";
$result_user=executeQuery($sql);
$line_user=mysql_fetch_array($result_user);

if($line_user[used_id]!=''){
   $temp_friendids_arr=array_reverse(explode(",",$line_user[used_id]));
   //sort($temp_friendids_arr);
} 

$no=1;
	  if(is_array($temp_friendids_arr)){
	  sort($temp_friendids_arr);
	  foreach($temp_friendids_arr as  $ind=>$val){
?>
                            <td width="149"><table border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#EFEFEF">
                                <tr> 
                                  <td bgcolor="#FFFFFF"><?=show_user_photo($val,$photo_type='small',$user_name='yes') ?></td>
                                </tr>
                              </table></td>
							 <?  if($no%4=='0') { echo "</tr><tr>";} $no++; } ?>	

				<? } else { echo "<td>&nbsp;</td>"; }?>
				</tr> <tr>	
						 </tr> 

                    </table>

NogDog

jasondavis wrote:

if($line_user[used_id]!=''){
   $temp_friendids_arr=array_reverse(explode(",",$line_user[used_id]));
   //sort($temp_friendids_arr);
}

$no=1;
      if(is_array($temp_friendids_arr)){
      [color=red]sort($temp_friendids_arr);[/color]

That sort() command (in red) is going to overwrite the array_reverse() you do earlier.

jasondavis

thanks I overlooked the 2nd one I guess 🙂

so there is no way to just get the last 24 in the string? It seems I need to get all of them which could be around 1,000 then grab the last 24?

 $temp_friendids_arr=array_reverse(explode(",",$line_user[used_id], 24));

and if that is the case how would I go about making $temp_friendids_arr only show 24 items

jasondavis

I found the code where it inserts this value into DB

$insertip=$fet['used_id'].",".$_SESSION['info']['auto_id'];

could I just add new id to the fron of the list?

NogDog

Well, what you probably really should do is have a relational table set-up where there is only one ID per row. I'm not real sure what you're trying to do, but I suspect it would be something like:

user_id
friend_user_id
timestamp

Then your query would be something like:

SELECT friend_user_id FROM table_name WHERE user_id="$userid" ORDER BY timestamp DESC LIMIT 24

But, if you're stuck working from an exploded array, you could get the last 24 entries via:

for($ix = 0; $ix < 24 and count($array); $ix++)
{
   echo "<p>" . array_pop($array) . "</p>\n";
}