[SOLVED] How to find the last index in an array?

[ballhogjoni]

Does anyone know how to do this? I ask because I am generating a where clause for mysql and I can't have an AND at the end of the where clause.

 

Ex:

affiliate_id = "47" AND affiliate_id = "43" AND affiliate_id = "85" AND affiliate_id = "337" AND affiliate_id = "341" AND

 

my code

foreach( $aAffiliates as $key => $value ){
$sWhere .= 'affiliate_id = "'.$value['id'].'" AND ';
}

[premiso]

Why not use the implode

 

<?php

$sWhere = implode("' AND '", $aAffiliates);

 

Should get what you want =)

[rhodesa]

instead, use:

$sWhere = array();
foreach( $aAffiliates as $key => $value ){
   $sWhere[] = 'affiliate_id = "'.$value['id'].'"';
}
$sWhere = implode(' AND ',$sWhere);

[ballhogjoni]

$aAffiliates is a multi array

[premiso]

$aAffiliates is a multi array

 

Yea, look at rhodesa's example. I just missed that it was a mutli-dimm array. =)

[ballhogjoni]

Aaron,

 

ty that works perfectly.

[DarkWater]

By the way, are you sure you want AND and not OR? =P  If you did really mean OR, I'd suggest just checking out the IN() construct.  It would make your life much easier.

[ballhogjoni]

yep thx for the help.

[ballhogjoni]

Nope need AND