[RESOLVED] how to make and entry value a negative number

imad_imike

How do I make a variable a negative number??

Ive got $row[EntryValue] and $row[EntryRW].

What I need to do is, if EntryRW equals '1', I need to make the Figure for EntryValue a negative number.

Does that make sense??

Ive come up with this but it doesnt seem to work, unless I'm just putting it in the wrong place,

if ($row[EntryRW]==1)
  	 {
        $row[EntryValue] = "-". $row[EntryValue];
  	 }

I'll, post a copy of my script aswell just incase im putting it in the wrong place

$SQL1 = "SELECT * FROM Entry WHERE UserID = '$userID' AND EntryAdjustment IS NULL AND (EntrySelect=4 AND (EntryBalanceSheet=1))";

$result1 = mysql_query($SQL1) or die(mysql_error());

$num_rows = mysql_num_rows($result1);

if ($num_rows > 0 )
  {
  $NoOfEntries=true;
  while($row = mysql_fetch_array($result1))
  {
   $rows[] = $row;
     if ($row[EntryRW]==0)
  	 {
        $row[EntryValue] = "-". $row[EntryValue];
  	 } 
  } 

  }

Any suggestions, Ideas, or general help is appreciated

Thanks

leatherback

If $row[EntryValue] is a string then what you do should work. if it is a number:

$row[EntryValue] = 0-$row[EntryValue];

imad_imike

$row[EntryValue] is a number.
$row[EntryRW] is either '1' or '2'

for example: if $row[EntryValue] is '100' and $row[EntryRW] is '1'
I want $row[EntryValue] to = '-100'

Does that clear things up a bit better?

Oh and as you can see I took your advice and got rid of the variables.

imad_imike

I forgot to mention that I tried

$row['EntryValue'] = 0 - $row['EntryValue']

It done nothing, the number just returned in its orignal possitive form.

Plz someone help!!!!

johanafm

imad imike;10986326 wrote:
$row['EntryValue'] = 0 - $row['EntryValue']

It done nothing, the number just returned in its orignal possitive form.

No, it really doesn't. You will change the sign of that array element.

However,

  while($row = mysql_fetch_array($result1))
  {
   # $row['EntryValue'] - positive or negative?
   $rows[] = $row;
   $rows[count($rows) - 1]['EntryValue'] - positive or negative?
     if ($row[EntryRW]==0)
       {
        $row[EntryValue] = "-". $row[EntryValue];
        # NOW you have changed the sign!

    # However, do you expect this ...
    $rows[count($rows) - 1]['EntryValue'] - positive or negative?
    # ... to also change sign?
   }
  }

And apart from that, turn on error reporting. $row[EntryValue] generates a warning, $row['EntryValue'] does not.

leatherback

... Which is why in the example given earlier things were in a different order:


 if ($row['EntryRW'] ==1)
  {
   $row['EntryValue'] = "-". $EntryValue;
  }

$rows[] = $row;

But indeed, if these missing quotes don't result in errors, you need to switch error reporting on, otherwise you cannot debug effectively (Which is what I pointed out in an other thread; Without my server I will miss these things, writing in normal notepad, without a testing option)