how to pull all of the data from an sql database and display it with php? : <p>so im trying to display countdowns to events which are stored with an my_sql table... the code im using is:</p>

<pre><code>&lt;?php // Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$query = "SELECT * FROM `customcountdowns` WHERE `name_of_event` = * ORDER 
BY name_of_event";
  if($query) // will return true if succefull else it will return false
{ echo "query is working";
// code here
}
$result = mysqli_query($conn, $query);
if(!$result) {
echo 'No results found.';
}
</code></pre>

<p>it puts out query is working and no results found... how would i get all of the data out of the table and display it? thanks in advance!</p>
