PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tableee ( `id` INTEGER, `tag` VARCHAR(21) ); INSERT INTO tableee (`id`, `tag`) VALUES ('1', 'wordpress, psd , html'), ('2', 'wordpress, html'), ('3', 'wordpress'), ('4', 'psd');
Copy Clear
Copy Format Clear
<?php $query = mysqli_query($mysqli, "SELECT * FROM `groups` order BY `id` ASC"); while ( $row = mysqli_fetch_array($query) ) { $group_id = $row["id"]; $gpc = mysqli_query($mysqli, "SELECT SUM(`points`) as TotalPoints FROM `points` WHERE `attempt_id` IN (SELECT `id` FROM `attempts` WHERE `status`=1) AND `group_id`=".$group_id); $gpcrow = mysqli_fetch_assoc($gpc); echo $row["title"]." : ".$gpcrow["TotalPoints"]; }
Show:  
Copy Clear