Hi everyone,

I have a column in my table which includes a number of cities. I might have 10 rows with the name 'London' and 5 rows with the name 'New York'. How can I print out all of the cities without the same names repeating themselves? So, one row for each individual city.

PHP Code:
require (MYSQL);
$q "SELECT city FROM messages";
$r = @mysqli_query($dbc$q);   
$num mysqli_num_rows($r);
    if (
$num 0) { 
 while (
$row mysqli_fetch_array($rMYSQLI_ASSOC)) { 

'<p>'.$row['city'] . '</p>';


Thank you in advance!