Needing some help with... replacements I would guess...

[krelian]

Ok, I have two different sets of numbers. I would like to combine them, but am having major difficulties in doing so. Here is what I am looking for:

First set - 1:100, 2:91, 15:12, 23:30, 53:100, 50:0, 91:2
Second Set - 50:1, 15:2, 19:2, 23:2, 90:2, 91:2

Ok, so how I am looking for it to go is like so. Where ever the numbers in the second line appear, but do not appear in the first, will simply be added. Thats easy enough to do.

But, for if the second set of numbers, on the left side of the colon is found, it will add up the numbers on the right side of the colon for the first line. It really kinda hard to explain. This is how it should look when its finished:
1:100, 2:91, 15:14, 23:32, 53:100, 50:1, 91:4, 19:2, 90:2

Bold are marking the changes, and italic is marking the additions. It doesn't matter at all what the order of the numbers is, as long as the keep the correct sides of the colon. Does anybody have an idea of what I can do to complete this task? Or any suggestions?

[autumn]

I'm not sure what format these numbers are in but I would split them and put them in a db (two seperate tables) and use SQL queries to do the matching and adding using joined tables.

a

[milind24]

I am not sure what exactly u want but what i undertsood is like below , try this :

$my_arry1 = array('1:100','2:91','15:12','23:30','53:100','50:0','91:2');
$my_arry2 = array('50:1','15:2','19:2','23:2','90:2','91:2');
for($i=0;$i<count($my_arry1);$i++)
{
	$fst = explode(":",$my_arry1[$i]);
	for($j=0;$j<=count($my_arry2);$j++)
	{
		$snd = explode(":",$my_arry2[$j]);
		if($fst[0] == $snd[0])
		{
			$my_arry1[$i] = $fst[0].":".(intval($fst[1])+intval($snd[1]));
			array_splice($my_arry2, $j, 1);
		}
	}
}
$my_arry1 = array_merge($my_arry1,$my_arry2);
$comma_separated = implode(", ", $my_arry1);
print "Final set  : ".$comma_separated."<br><br>";

[MeX]

hi krelian!

i love arrays ... so my solution:

<?php

// try to get your strings to arrays like that
$set01 = array(
1 => 100,
2 => 91,
15 => 12,
23 => 30,
53 => 100,
50 => 0,
91 => 2
);

$set02 = array(
50 => 1,
15 => 2,
19 => 2,
23 => 2,
90 => 2,
91 => 2
);

$result = $set01;
reset($result);
while(list($key, $value) = each($set02)) {
if (array_key_exists($key, $result)) {
$result[$key] = $value + $result[$key];
} else {
$result[$key] = $value;
}
}

echo "<pre>result ==> "; print_r($result); echo "</pre>";

?>

here you are ... hope that helps!!

ceeyaa.MeX

[krelian]

Thanx guys. I will try both of them out and let you know if its working!

Place an edit here:
For milind24
K, its working great if the numbers are concreate and actually set up in the array.
ex: array('1:100', 2:12', etc, etc.);
But I would like to make them interchangeable numbers. I have even set up so that it is extracted into a variable set up with the 'x:y', part to it. But when I put that into the array:
array($firstset);
It prints out the final with the first set and then the second. So the numbers appear like: $firstset $secondset. It doesn't add up. Surely this one isn't complicated to do, but I cannot seem to get it to go. Any ideas with that part?

Sorry, need to be more specific eh?
Here is how I set up the variables:

$makeknown = str_replace(" ", "', '", "$bbuserinfo[firstset]");
                $makeknown = "'$makeknown'";
$makeaddnew = str_replace(", ", "', '", "$findnew[new]");
	$makeaddnew = "'$makeaddnew'";

When I echo that out, I gets numbers like:
'1:100', '2:12', etc, etc.
and same for the second, so they are set up like the 'x:y', kinda way, with no ending comma. But when I put that into the array
my_array1 = array($makeknown);
it doesn't work. K, hopefully that gives enough background!

[MeX]

hi krelian!

sorry ... nothing understood!?
what's the problem now?
to convert your string to the arrays?

ceeyaa.MeX

[krelian]

Uh, yeah thats what I am looking for, methinks.

I cannot get my string to go into an array correctly. Like I mentioned, it works fine if it is set up as:
$myarray = array('1:100', '2:2', whatever);
but I want to use a string of info like so:
$myarray = array('$string');
And that doesn't work.

The above post shows how I have formatted the string, so it appears like the '1:100', '2:2', etc, etc, with the whole 'x:y', thing. Any ideas? Cause I am lost.

[milind24]

hey I think you shold assign as like

$my_array1 = $makeknown; 

can you paste all code as it is , here , so imm. we will find whats going wrong

[krelian]

Sure, this is what I got:

	$makeknown = str_replace(" ", "', '", "$bbuserinfo[firstset]");
	$makeknown = "'$makeknown'";

$findsecond = $DB_site->query_first("SELECT * FROM secondset WHERE id = '$bbuserinfo[secondselect]'");
	$maketeach = str_replace(", ", "', '", "$findsecond[numbersets]");
	$maketeach = "'$maketeach'";

$my_arry1 = $makeknown; 
$my_arry2 = $maketeach; 
	for($i=0;$i<count($my_arry1);$i++) { 
		$fst = explode(":",$my_arry1[$i]); 
	for($j=0;$j<=count($my_arry2);$j++){ 
		$snd = explode(":",$my_arry2[$j]); 
	if($fst[0] == $snd[0]){ 
if ($fst[1] >= 100){
	$my_arry1[$i] = $fst[0].":".(100);
	}else{
$my_arry1[$i] = $fst[0].":".(intval($fst[1])+intval($snd[1])); 
}
array_splice($my_arry2, $j, 1); 
} 
} 
} 
$my_arry1 = array_merge($my_arry1,$my_arry2); 
$comma_separated = implode(", ", $my_arry1); 
print "Final set : ".$comma_separated."<br><br>";

echo "Known : $makeknown<br>Taught : $maketeach<br>";

k, and with the $my_arry1 = $makeknown;, I get this error:
Warning: First argument to array_splice() should be an array in /www.gamers-forums.com/vb/aaa.php on line 568

Also, I have the $makeknown and $maketeach added too, and they echo everything like this:

Final set : '1:100', '2:91', '15:12', '23:30', '53:100', '50:0', '91:2', '90:2', '75:100', '76:100', '77:100', '78:100', '79:100', '80:100', '81:100', '82:100', '83:100', '84:100', '85:100', '86:100', '87:100', '50:1', '15:2', '19:2', '23:2', '90:2', '91:2'

First Set: '1:100', '2:91', '15:12', '23:30', '53:100', '50:0', '91:2', '90:2', '75:100', '76:100', '77:100', '78:100', '79:100', '80:100', '81:100', '82:100', '83:100', '84:100', '85:100', '86:100', '87:100'

Second Set : '50:1', '15:2', '19:2', '23:2', '90:2', '91:2'

EDIT: Wow, what a mess to look at eh? Sorry about that 😉

[milind24]

can you explain little bit what are u doing here , how you getting values :

$makeknown = str_replace(" ", "', '", "$bbuserinfo[firstset]");
    $makeknown = "'$makeknown'";

$findsecond = $DB_site->query_first("SELECT * FROM secondset WHERE id = '$bbuserinfo[secondselect]'");
    $maketeach = str_replace(", ", "', '", "$findsecond[numbersets]");
    $maketeach = "'$maketeach'";

[krelian]

Sure.
The numbers that I wish to use, are stored in mediumtext fields in the DB. So, with the first one, the numbers are set up like:
1:100 2:10 50:1 whatever, whatever.
So the first set is to add the commas and the apostrophies. Now its like:
'1:100', '2:10', '50:1' etc. (I assume this will aid in the use of the arrays)
Same with the second set, but the difference is it already has the commas in it:
50:1, 90:2, etc, etc.

Oh, and to get the second set of numbers, it is relative to the second set of number that a user has selected.

That is why it has the $DB query in it.

(Set #1 = 1:100, 50:1, etc, etc.)
$DB_site->query("SELECT * FROM table WHERE id='$set1'");

Erm, I hope that is what you needed!

[milind24]

Hey u have no need of then do replace by commas or all what wer you have done , use this code it will work
You got input as tab or space separated then do like this

$findsecond = $DB_site->query_first("SELECT * FROM secondset WHERE id = '$bbuserinfo[secondselect]'");
$maketeach = $findsecond[numbersets];
$my_arry1 = explode(" ",$makeknown); 
$my_arry2 = explode(" ",$maketeach); 

for($i=0;$i<count($my_arry1);$i++) 
{ 
	$fst = explode(":",$my_arry1[$i]); 
	for($j=0;$j<=count($my_arry2);$j++)
	{ 
		$snd = explode(":",$my_arry2[$j]);
		if($fst[0] == $snd[0])
		{ 
			if ($fst[1] >= 100)
			{
				$my_arry1[$i] = $fst[0].":".(100);
			}
			else
			{
				$my_arry1[$i] = $fst[0].":".(intval($fst[1])+intval($snd[1])); 
			}
			array_splice($my_arry2, $j, 1); 
		} //if ends
	}// 2nd for ends 
}// 1st for ends

$my_arry1 = array_merge($my_arry1,$my_arry2); 
$comma_separated = implode(", ", $my_arry1); 
print "Final set : ".$comma_separated."<br><br>";

echo "Known : $makeknown<br>Taught : $maketeach<br>";
?>

[krelian]

Alright, it works great! That is exactly what I am looking for!

Thanx very much for your help guys!