- You are not logged in. | Login
February 21, 2007 9:03 am
- mellis
- Member
Comparison of parameter??™s values within a cycle
Help me please with an idea for such a relative case:
$result = SQL_Query('select * from tablename where conditions order by parameter');
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++) {
$row = mysql_fetch_array($result);
echo $row["parameter"].', ';
}I??™d like to do it in a way which enables evading parameter??™s displaying in case it is equal. I.e. instead of "5, 5, 5, 5, 7, 7, 7, 9, 9, 9", for instance, I??™d like to have displayed "5, -, -, -, 7, -, -, 9, -, -,". I should compare the current parameter??™s value with the previous one. But how can I do this?
I hope someone helps me.
February 21, 2007 9:07 am
- franzkafka
- Member
Re: Comparison of parameter??™s values within a cycle
You are to memorize current value within a variable.
February 21, 2007 9:16 am
- mellis
- Member
Re: Comparison of parameter??™s values within a cycle
Sure, but I need to change it somehow by every iteration. And how should I do this? I need to manage variables of variables somehow but what should I do?
February 21, 2007 9:20 am
- franzkafka
- Member
Re: Comparison of parameter??™s values within a cycle
You are to memorize them within variable.
February 21, 2007 9:25 am
- Conker
- Member
Re: Comparison of parameter??™s values within a cycle
The last string of the cycle should be
$temp = $row["parameter"];
By the output you are to compare $temp and $row["parameter"] against their equality.
February 21, 2007 9:28 am
- mellis
- Member
Re: Comparison of parameter??™s values within a cycle
But if I do so they will always be equal. In each iteration $temp will take the current value of parameter. But I need $temp which is equal to the previous value.
February 21, 2007 9:34 am
- franzkafka
- Member
Re: Comparison of parameter??™s values within a cycle
Instead of pondering you??™d better do what I say.
February 21, 2007 9:39 am
- mellis
- Member
Re: Comparison of parameter??™s values within a cycle
I??™ve managed it, thanks.
if($row["parameter"]!=$temp) echo $row["parameter"].', '; else echo '_, '; $temp=$row["parameter"];
Something like this.
February 21, 2007 9:49 am
- Conker
- Member
Re: Comparison of parameter??™s values within a cycle
Sure but??¦ You are to declare $temp before cycle or you will get a warning.
