davidolson Posted March 27, 2014 Share Posted March 27, 2014 $TotalCashoutsQuery = "SELECT amount FROM cashouts_pending WHERE status = :status"; $TotalCashouts = $dbh->prepare($TotalCashoutsQuery); $TotalCashouts->bindValue(':status', 1, PDO::PARAM_INT); $TotalCashoutsNumRow = $TotalCashouts->rowCount(); if($TotalCashoutsNumRow > 0){ while($TotalCashoutsRow = $TotalCashouts->fetch(PDO::FETCH_ASSOC)){ $TotalCashoutsMade = $TotalCashoutsMade + $TotalCashoutsRow['amount']; } }else{ $TotalCashoutsMade = '0'; } Why is $TotalCashoutsMade UNDEFINED VARIABLE Link to comment https://forums.phpfreaks.com/topic/287326-undefined-variable/ Share on other sites More sharing options...
Ch0cu3r Posted March 27, 2014 Share Posted March 27, 2014 Because on the first iteration of the while loop $TotalCashoutsMade is not defined. To prevent the notice you should initialise this variable before the while loop $TotalCashoutsMade = 0; // init $TotalCashoutsMade to zero if($TotalCashoutsNumRow > 0){ while($TotalCashoutsRow = $TotalCashouts->fetch(PDO::FETCH_ASSOC)){ $TotalCashoutsMade += $TotalCashoutsRow['amount']; // add $TotalCashoutsRow['amount'] to $TotalCashoutsMade } } No that $TotalCashoutsMade is defined before the while loop, the else statement is not needed. Link to comment https://forums.phpfreaks.com/topic/287326-undefined-variable/#findComment-1474093 Share on other sites More sharing options...
davidolson Posted March 27, 2014 Author Share Posted March 27, 2014 Thanks for help Link to comment https://forums.phpfreaks.com/topic/287326-undefined-variable/#findComment-1474094 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.