Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE phrases (id int primary key auto_increment, episode varchar(64));
INSERT INTO phrases (episode) VALUES ('episode1'), ('episode2'), ('episode3'), ('episode1');
<?php
$link = &$mysqli;
$episode = mysqli_real_escape_string($link, 'this\course');
echo $episode;
$query = mysqli_query($link, "SELECT COUNT(DISTINCT episode) FROM phrases");
$row = mysqli_fetch_row($query);
$total = $row[0];
$query_f = mysqli_query($link, "SELECT COUNT(*) FROM phrases WHERE episode='$episode'");
$phrases = mysqli_fetch_row($query_f);
$total_f = $phrases[0];
echo "COUNT: " . $total_f;