Extracting values from String

kamy99

Hi all:

I have a numeric variable that is between 2-12 characters long and it's always even (2,4,6,8,10,12 characters)

What I need to do is this:

Grab each pair of values and run a query on them.
For example if my variable is :
$dummy= 213455

I want to grab 21, run a query, then grab 34 run a query. Then grab 55 run another query.

I'm sure you get the idea!

Please help!

Thanx
Kamy

Anon

Try something with array_chunk

(array_chunk($input_array, 2));

or array_slice

array_slice ($input_array, 0, 2);

or even array_shift

see the manual for more on these array options.

HTH

jonb

kamy99

Hi again:

I've been able to solve the first part of the problem, ie extracting the values. However, I'm still struglling with the query part. My code so far looks like this

<?
// lets get the lenght of string first

$rcLength = strlen($rcCodes);

for ($i=0; $i< $rcLength; $i+=2)
{
$RCactual=substr($rcCodes,$i,2);

echo "<table bgcolor=orange><tr><td>$RCactual</td><td></td><tr></table>";
$getRC = mysql_query("SELECT * FROM equifaxrc WHERE RC_Number=$test");

}
?>

Problrm is, when I try to run a "while" to display I get an error message.

Any ideas?

plasko

Where does the variable $test come from?

That might be your problem.