PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE phrases (id int primary key auto_increment, episode varchar(64)); INSERT INTO phrases (episode) VALUES ('episode1'), ('episode2'), ('episode3'), ('episode1');
Copy Clear
Copy Format Clear
<?php $link = &$mysqli; $episode = mysqli_real_escape_string($link, "Kim\'s \\n"); 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;
Show:  
Copy Clear