Why is my if ... else not working?

[NEX2NUN]

I am still grasping the functions of "if ... else" statements. I did have some luck creating a SINGLE user details page and was able to write the following with much success.

<?php

$acresbenefited = $row_printWatershed['ab'];
$acresmin = $row_benefits['min'];
$acresvalue = $row_benefits['acre'];

$acresnotnull = ($acresbenefited * $acresvalue);

$notnullbenefit = ($acresnotnull * 3);
$nullbenefit = ($acresmin * 3);

?>

<?php

	if($acresbenefited == '') {
		echo "$acresmin";
	} else  {
		echo "$acresnotnull";
	}

?>

However, now I am trying this statement on a page listing ALL users and this function is only selecting the first row and repeating it through the remaining user rows. Not sure how to get a function like this to work in my new details page. Any suggestions?

Thank you!

[NogDog]

Sounds like you probably need some sort of loop; but there is not enough info here (at least for me) to determine if we are talking about a while() loop on a database result, a foreach() loop on an array, or something else.

[NEX2NUN]

I think I got it. I figured the echo of the $value was not generated a loop (like you mentioned), so I tried something else:

<?php

if($row_printWatershed['ab'] == '') {
	echo $row_printWatershed['min'];
} elseif($row_printWatershed['ab'] > '1') {
	echo $row_printWatershed['ab'] * $row_printWatershed['acre'];
}

?>

Using the $row_value I believe generated the loop needed (if I understood that to be true) and was able to use my math function in the result.

Awesomeness!!!

[NEX2NUN]

NogDog;10901675 wrote:

Sounds like you probably need some sort of loop; but there is not enough info here (at least for me) to determine if we are talking about a while() loop on a database result, a foreach() loop on an array, or something else.

Do you think I can somehow get the SUM of all totals that is generated by this loop?

<?php

if($row_printWatershed['ab'] == '') {
	echo $row_printWatershed['min'] * 3;
} elseif($row_printWatershed['ab'] > '1') {
	echo $row_printWatershed['ab'] * $row_printWatershed['acre'] * 3;
}

?>

[laserlight]

NEX2NUN wrote:

Do you think I can somehow get the SUM of all totals that is generated by this loop?

Yes, e.g., by keeping a $total variable and adding to it.

[NEX2NUN]

laserlight;10901681 wrote:

Yes, e.g., by keeping a $total variable and adding to it.

Thanks laserlight,

what would an explain of that look like though?

[NEX2NUN]

I was going to add to my question how to round up using php, but I just read the PHP manual for round and figured this into my if ... else.

<?php

if($row_printWatershed['ab'] == '') {
	echo $row_printWatershed['min'] * 3;
} elseif($row_printWatershed['ab'] > '1') {
	echo round($row_printWatershed['ab'] * $row_printWatershed['acre'] * 3,2);
}

?>

[NEX2NUN]

NEX2NUN;10901700 wrote:

Thanks laserlight,

what would an explain of that look like though?

I meant for that too read, what would an example be. I'm not sure I can visiualize what that would look like. Thank you.

[laserlight]

Well, where's the loop? You would need to initialise this running total to 0 before the loop, but at the moment you have not shown the part where you added the loop.

[NEX2NUN]

laserlight;10901761 wrote:

Well, where's the loop? You would need to initialise this running total to 0 before the loop, but at the moment you have not shown the part where you added the loop.

This is where I will be learning a lot.

I'm not sure if I have a loop. Do I?

[laserlight]

NEX2NUN wrote:

I'm not sure if I have a loop. Do I?

No, you have an if statement chained with an elseif statement.

[NEX2NUN]

laserlight;10901763 wrote:

No, you have an if statement chained with an elseif statement.

I really am not sure how to write the loop for this, I believe I understand how to add the $total to my "if ... else" but not sure how the loop would tie into that.

<?php 

$total = 0;

for ( not sure what to do here );

?>


<?php

if($row_printWatershed['ab'] == '') {
	echo $row_printWatershed['min'] * 3 + $total;
} elseif($row_printWatershed['ab'] > '1') {
	echo round($row_printWatershed['ab'] * $row_printWatershed['acre'] * 3 + $total,2);
}

?>

I have really begun to understand a lot of this and thanks a lot in part to you and php builder (I have read a lot of your responses in other threads). I understand the loop a bit but not sure how to implement it.

[laserlight]

Well, how did you get $row_printWatershed['ab']? How did you display all the users? Surely you used a loop there, and it is that loop that you should be concerned with.

Also, if you used a relational database you could get this count using an SQL statement.

[NEX2NUN]

laserlight;10901766 wrote:

Well, how did you get $row_printWatershed['ab']? How did you display all the users? Surely you used a loop there, and it is that loop that you should be concerned with.

Also, if you used a relational database you could get this count using an SQL statement.

You are very right! I understand how I can achieve this by using SQL, however, a wrench was thrown into the works and we are having to add an expression to total achieve new values from the database, without having to update all user data (which would take awhile). I guess I'm trying to create a workaround, hoping it's being done the right way. So far so good, just this one thing I can quite grasp.

Here is how I get the $row_printWatershed['ab'] variables. (Using Dreamweaver CS3)

<?php
mysql_select_db($database_conn, $conn);
$query_printWatershed = sprintf ("

SELECT *
FROM owners, ditches
WHERE owners.number = %s AND owners.number = ditches.number ORDER BY owners.name ASC",

GETSQLValueString($colname_printWatershed, "text"));
$printWatershed = mysql_query($query_printWatershed, $conn) or die(mysql_error());
$row_printWatershed = mysql_fetch_assoc($printWatershed_;
$totalRows_printWatershed = mysql_num_rows($printWatershed);

?>

And thank you laserlight for helping me, it's just this one thing and I've got it where I need it too be for now.

[Weedpacket]

$row_printWatershed = mysql_fetch_assoc($printWatershed_;

Typo aside, that will only give you the first row returned by the query. You're not doing anything there to get the rest.

[NEX2NUN]

Weedpacket;10901770 wrote:

Typo aside, that will only give you the first row returned by the query. You're not doing anything there to get the rest.

Okay. I think I understand that Weekpacket, and thank you. However, what can I do to get the rest?

[NEX2NUN]

Weedpacket;10901770 wrote:

Typo aside, that will only give you the first row returned by the query. You're not doing anything there to get the rest.

@ - I don't fully understand the definition of either but would a mysql_fetch_array be better to use in this loop?

I wish I knew the terms to use but what I am after is using the data pulled from the database, that is then manipulated through the php if/else I wrote and then using both of those in turn to get a sum for that row. I just don't know how to go about doing that.

Newb alert (but I'm learning honest!)

[laserlight]

NEX2NUN wrote:

I don't fully understand the definition of either but would a mysql_fetch_array be better to use in this loop?

No. The problem is that there is no loop. I would expect something like this, assuming that you have connected to the database and defined the $colname_printWatershed variable before the code snippet:

<?php
mysql_select_db($database_conn, $conn);
$query_printWatershed = sprintf("SELECT * FROM owners, ditches
    WHERE owners.number = %s AND owners.number = ditches.number
    ORDER BY owners.name ASC",
    GETSQLValueString($colname_printWatershed, "text"));
$printWatershed = mysql_query($query_printWatershed, $conn)
    or die(mysql_error());
$totalRows_printWatershed = mysql_num_rows($printWatershed);
while ($row_printWatershed = mysql_fetch_assoc($printWatershed)) {
    // Print the data here.
}

// ...
?>

[NEX2NUN]

Okay I think I really need to go about this another way, you both have suggested using my database rather than this function and I believe that would be a better route. Because what I am doing now is using PHP to update data from the tables, rather than just updating the tables to then use in my PHP.

So here's my next question, how can I write and IF,ELSE statement for MySQL to UPDATE my tables. (http://dev.mysql.com/doc/refman/5.0/en/if-statement.html).

I figured something like this would be what I'm after, just my syntax must not be correct. Again what I am after is too update the tables with the if,else statements.

IF owners.ab = ' '
INSERT ditches.min INTO owners.ast FROM owners, ditches WHERE owners.id = '504' AND owners.id = ditches.id
ELSE
INSERT (owners.ab * ditches.acre) INTO owners.ast FROM owners, ditches WHERE owners.id = '504' AND owners.id = ditches.di
END IF;

So what that should read is:

If the owners ab column is empty,
insert the ditches min amount into owners ast column where the owners id is 504 and join ditches id with owners id
if it is not empy
then insert the owners ab column multiply by the ditches acre column into the owners ast column from the owners table where the owners id is 504 and join the ditches id with owners id

Does that make sense at all? And how would I do that? Please and THANK YOU so very much!

[NEX2NUN]

I really was thinking WAY over the top with this.

To update the database tables, simply create a php form!!! I am even able to use the php math functions to get the values to update the columns.

Now my only problem is, it's not updating my database. Not sure if I setup my join correctly or not.