PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table active_users ( affiliate_id int, user_value int ); insert into active_users values (50, 13),(50, 12); SELECT sum(user_value) as sum FROM active_users WHERE affiliate_id=50;
Copy Clear
Copy Format Clear
<?php $conn = &$mysqli; $query = "SELECT sum(user_value) as sum FROM active_users WHERE affiliate_id=50"; $result = mysqli_query($conn, $query); $affiliate_total_earn = mysqli_fetch_assoc($result)['sum']; echo "Affiliate total earn: " . $affiliate_total_earn;
Show:  
Copy Clear