Am I missing something here?

Am I missing something here? I'm getting a blank screen in return to this code:

<?php

include 'config.php';
include 'opendb.php';


$query  = "SELECT city, countyurl, abbr FROM demographic WHERE cityurl='cityurl' GROUP BY cityurl";
$result = mysql_query($query);

while(list($city,$countyurl,$abbr)= mysql_fetch_row($result))
{
    echo "<a href=\"/$sub_city/$abbr-$countyurl-$cityurl.html\">$city ($abbr)</a> <br> ";
}

include 'closedb.php';
?>

PHP:

in the 'head' I already have:

$sub = $_GET['sub'];
$cityurl = $_GET['cityurl'];

Thanks for any help!!!

 

Shouldn't:

$query  = "SELECT city, countyurl, abbr FROM demographic WHERE cityurl='cityurl' GROUP BY cityurl";

Code (markup):

Be this:

$query  = "SELECT city, countyurl, abbr FROM demographic WHERE cityurl='[b]$cityurl[/b]' GROUP BY cityurl";

Code (markup):

 

yep... you're right. Can't believe I missed that. THANKS!

 

No problem.