Hey all,
Seems I get one issue fixed and I run into another I can’t solve after hours of researching and rewriting.
had this working by simply passing the data from one variable to another like so:
$CalcsSets = $DisplayCalcs;
without the need to use the loop inside the if() statement and it inserted the data without quotes but all of a sudden it’s stopped working and I’m not sure why (it only started showing last integer), so I went with the more complex code trying to get it to work again as shown below.
Here’s the complex code I’m working with:
for($i=1; $i<=$CalcSets; $i++){
$calculations = PerformCalc($min, $highest, $OperatorType);
echo 'Calculations performed for '.$SetText[$i];
foreach ($calculations as $key => $DisplayCalcs) {
echo $SetCalc[] = $DisplayCalcs.', '; //stores calculations with ',' in
//array.
}
if($CalcSets == 1){
for($i=0;$i<$CalcSets;$i++){
$SetResults = $SetCalc[$i];
echo '<strong>'.(string)$SetResults.'</strong>';
}
DB_Insert($SetResults);
}
What it’s supposed to do is insert values in the following format (1,2,3,4,5,) into the database in a VARCHAR row but now all it shows is the last integer with no comma. I originally wanted to just store the integers and not a comma but I couldn’t get it to display on the page with commas after each integer so I went this route as mentioned earlier.
I realize I’m probably going about this the wrong way, but if any of you know a much easier, and shorter, way to do what I want, I’d be extremely appreciative of the help.
Reason I’m doing it this way, is because on the results page, it needs to show in the format mentioned above and there is another conditional if() that allows the user to select which results they’d like to keep if $CalSets is >= 2.
FYI, I did check the DB row and it is still set to VARCHAR with a length of 10 at the moment.