count array question

[emma57573]

Sorry Ive been stuck alot the last few days.

 

I have some code that counts my array thats working fine and Ive been running various functions using it.

 

This is working:

  $countseller=array();
  

while($rst) {

$seller_id= $rst["seller_user_id"];
				   			 
$countseller[]= $seller_id;

$countarray = array_count_values($countseller);

				  

if ($countarray[$seller_id] == 1 ){

DO WHAT I NEED TO DO WORKS FINE
}

if ($countarray[$seller_id] > 1 ){

DO WHAT I NEED TO DO WORKS FINE
}

 

 

 

Right now what I want to do is ask:

IF ($countarray[$seller_id] (IF IS IS THE LAST SELLER_ID IN THE ARRAY){

THEN DO WHAT I NEED TO DO

}

 

Is that possible or is that a no go?

Im thinking its a no go as Its in a while loop so I guess the code cant look ahead to something that hasnt been written

Is there away around this?

 

 

 

[Fadion]

First four counting an array, you can use count(). So:

 

<?php
if(count($array) == 1){
     //do something
}
?>

 

To check if a certain key is the last, you'll have to iterate through the array, as otherwise it makes no sense. Check out this code:

<?php
foreach(array_keys($array) as $key){
if($key == array_pop(array_keys($array))){
	echo $key . ' is the last key.';
}
}
?>

 

Hope this helps.

[emma57573]

Thats helpful and it works but the trouble is the array is in a while loop that adds keys to the array on every loop. If I add it in the loop it reads the last key on every loop and if I add it on the outside of the loop it will only read it for the last key.

 

For example this is the page:

 

 

The columns across are 'price' , 'qty' , 'shipping cost' and then 'sub total'

 

What Im trying to input is the FINAL Total from each seller and then a payment in each sellers box.

 

So if you see the small 16.00 in the left hand corner thats the code ive just added outside the while loop which is working but ONLY for the last seller in the loop. If I add it inside the loop then what happens is it adds the total after every product which of course is not what I want to do.

 

Im thinking that this is a no go and I need to re think the way Ive written this whole page as its starting to get messy to be honest.

Maybe I need to write the whole array before putting it in a while loop some how?

 

This is the code that controls the loop:

<?php

$config=mysql_fetch_array(mysql_query("select * from mytable_config"));
$freetplq_cur="select * from mytable_currency where user_id=".$config['cur_id'];
$freetplrow_cur=mysql_fetch_array(mysql_query($freetplq_cur));
$freetpl_fee_currency=$freetplrow_cur['cur_name'];

$query="select *,UNIX_TIMESTAMP(get_date) from mytable_sold where buyer_user_id=".$userid." and to_pay=1 order by seller_user_id DESC";
//echo $freetplquery;
$sql=mysql_query($query);
$rst=mysql_fetch_array($sql);
                        



$subshipping = preg_replace("/[^0-9\.]/", "", str_replace(',','.',$subshipping));
            $cents = '.00';
    
            $subshipping = preg_replace("/[^0-9]/", "", $subshipping);
           

$subshipping=0.00;



$total = preg_replace("/[^0-9\.]/", "", str_replace(',','.',$total));
            $sents = '.00';
    
            $total = preg_replace("/[^0-9]/", "", $total);
           


                        




?>


<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
  <tr>
    <td><h1>Payment Form </h1> 
				</td>
  </tr>

     
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" >
  <tr> 
    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
       <tr> 
          <td valign="top"> <div align="center"> 
              <table width="100%" border="0" cellpadding="1" cellspacing="0">
                <tr> 
                  <td align="center" valign="middle"> 
                    <? 
		                     
				if ($rst)
			    {





			  ?>
                    <table width="100%" border="0" cellspacing="2" cellpadding="5" class="onepxtable">
                     <tr><td>

				 <table cellpadding="0" cellspacing="0" border="0">
				 <tr><td>

                      <?
				  $cnt=0;
				  $countseller=array();
                      while($rst) {

				   $seller_id= $rst["seller_user_id"];
				   


				  			
				  	$total=0.00;


$countseller[]= $seller_id;

$countarray = array_count_values($countseller);

				  
				   $aid=mysql_fetch_array(mysql_query("select * FROM freetplclassified_products WHERE user_id=".$rst["pid"]));
				   
				   	$freetplq_img=mysql_fetch_array(mysql_query("select * from freetplclassified_images where  pid=".$rst["pid"]));



if ($countarray[$seller_id] == 1 ){

				  ?>

				     </tr>
				  </table>
				  
				  <table class="onepxtable" width="100%" cellpadding="5">
				  <tr>
				  </td>
				  <? } ?>


 <?  $mid=mysql_fetch_array(mysql_query("select * FROM freetplclassified_members WHERE user_id=".$rst["seller_user_id"]));





if ($countarray[$seller_id] >1 ){

    


?>

                      
					   
					   <? }else{ ?>
					   
					          <td width="12%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>">
							 <font class="smalltext">  <a href="view_profile.php?user_id=<? echo $rst["seller_user_id"];?>" onclick="window.open(this.href); return false;"><? echo $mid["username"];?></a></font> </td>
							 <? } 
							 ?>				   
					</tr>
                      <tr> 
				   <td width="9%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>">	  
				   
				   <a href="product_desc.php?user_id=<? echo $rst["pid"];?>" onclick="window.open(this.href); return false;">

						  <img src="uploadedimages/<?php echo $freetplq_img["url"]; ?>" border="0" width="70" height="70"></a></td>
                        <td width="28%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext"> 
                             <a href="product_desc.php?user_id=<? echo $aid["user_id"];?>" onclick="window.open(this.href); return false;"><? echo $aid["product_name"];?></a>
                      
                          </font></td>
                        <td width="10%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext">
                          <? 
				  if($rst["buy_price"]>0)
				  {
				  echo $freetpl_fee_currency.' ';
				  printf("%0.2f",$rst["buy_price"]);
				  }
				  else
				  {
				  echo "<font class='red'>($freetpl_fee_currency ";
				  printf("%0.2f",$rst["buy_price"]*(-1));
				  echo ")</font>";
				  }?>
                        </font></td>


                        <td width="12%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext">  
                          <? echo $rst["quantity"];?>
                          </font></td>
					  
					  
                        <td width="17%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext">     <? 

					$uid=mysql_fetch_array(mysql_query("select * FROM freetplclassified_altaddress WHERE uid=".$userid));
				$shipping_price=$rst["shipping_price"];
				$combine_shipping_price=$rst["combine_shipping_price"];
				$worldwide_shipping_price=$rst["worldwide_shipping_price"];
				$worldwide_combine_shipping_price=$rst["worldwide_combine_shipping_price"];
				$qty=$rst["quantity"];
				$buyprice=$rst["buy_price"];


				  if (($rst["quantity"]==1)&&($uid["country"]==1)){
				  
				  echo $shipping_price;
				  
				  }else if (($rst["quantity"]==1)&&(!$uid["country"]==1)){
				  
				  echo $worldwide_shipping_price;
				  
				  }else if (($rst["quantity"]>1)&&($uid["country"]==1)){

				 $subshipping += ($combine_shipping_price * $qty);

				  echo number_format($subshipping.$cents,2,'.','');
				  
				  
				 }else if (($rst["quantity"]>1)&&(!$uid["country"]==1)){

				 $subshipping += ($worldwide_combine_shipping_price * $qty);

				   echo number_format($subshipping.$cents,2,'.','');
				  
				  }
			?>	</font>  </td>

			<td width="17%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext">  
			<?
			$total= $rst["total"];

				echo number_format($total.$sents,2,'.','');


			?>


			</font></td></tr>

					  	
	  		<tr>
			<td width="17%" align="left" class="<? if($cnt%2<>0){echo "innertablestyle"; }else{echo "alternatecolor";}?>"><font class="smalltext">  
			<?


//$result="SELECT sum(total) as total FROM freetplclassified_sold WHERE seller_user_id=".$seller_id;
//$php = mysql_query($result); 
//if ($php) { 
//  $row = mysql_fetch_array($php); 
//  	echo $row['total']; 

//} 




    



			?>


			</font></td>



				  
				  
				   <?

				  $rst=mysql_fetch_array($sql);
        			  $cnt++;            
				}// end while
				?>




			 	</td></tr>
                    </table>

							<? 
$result="SELECT sum(total) as total FROM freetplclassified_sold WHERE seller_user_id=".$seller_id;
$php = mysql_query($result); 
if ($php) { 
   $row = mysql_fetch_array($php); 
   
   
   
foreach(array_keys($countarray) as $seller_id){
if($seller_id == array_pop(array_keys($countarray))){

echo $row['total']; 


     }
   }
} ?>
                    <?
				 }// end transaction found
				 else
				 {
				 //////////////////////////////////////////////////////------------------
				?>
                    <table width="100%" border="0" cellspacing="2" cellpadding="0" class="onepxtable">
                      <tr align="center" class="titlestyle"> 
                        <td height="25" align="left"> No Items to pay for  </td>
                      </tr>
                      <tr align="center"> 
                        <td align="left" class="innertablestyle"><font class="normal"> You do not have any items to pay for. </font></td>
                      </tr>
                    </table>
                    <?php 
				/////////////////////////////////////////////////////------------------------------------------
				}	//end else i.e. no transaction found 
                        
                  ?></td>
                </tr>
                <tr> 
                  <td align="center">  </td>
                </tr>
              </table>
            </div></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td valign="top"> </td>
  </tr>
</table>

 

What you say thats messy, should I just scrap it and start again?