First, provide the query with what you need instead of wildcarding it. You should always do this instead of requesting for *. In this case all you need is
SELECT c_name FROM tblclubs ORDER BY c_name ASC. Note that you should also provide an order by all the time; DBMS provide absolutely no guarantee in an order unless you have specified it.
Next, mysql and mysqli libraries are different beasts. The problem here is lack of error checking; the $con isn't established as a valid mysqli object, so each call from mysqli_query on will fail. Where have you constructed the $con variable?
header('HTTP/1.1 420 Enhance Your Calm');