PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE phrases (id int primary key auto_increment); INSERT INTO phrases VALUES ();
Copy Clear
Copy Format Clear
<?php $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