Display row where strpos 0,1 are matched

[wright67uk]

I'm looking to only return rows where the first two letters of $_attributeSelection["backp1"] are GB

I'm sure I need to use strpos somehow, but Im not sure how to use it with my code can anyone show me how?

 

<?php
foreach ($selections as $_selection) {
$_attributeSelection = $_selection->attributes();
?>
<tr>
<td>
<?php echo $_attributeSelection["name"] ?> 
</td> 

<td>
<b><?php echo $_attributeSelection["backp1"] ?></b><br/> 
</td>

</tr>
 

 

[kicken]

If you are interesting in the first two letters specifically rather than GB appearing anywhere in the string, then use substr.

if (substr($_attributeSelection['backp1'], 0, 2)=='GB'){

}

[Barand]

You could also do it in the MySql query

 

... WHERE SUBSTRING(backp1 ,1, 2) = 'GB'