Data base info won't display on webpage

[chilik]

Hello There!
I've created a data base with 4 columns "city, zipcode, dfw, love) 2 of these columns should be visible on my web page: http://www.riva-limo.com/rates.php
After the surfer is choosing the airport from the drop-down list he should see "Select a city..." in the next field and then he will be able to choose from a drop-down list of cities.
My problem is that it seems that the information from the data base is loaded to that field but it is not visible, and if you blindly select from the cities list you can see the same problem happening again in the zip code field.
My code looks like this:

if ($_GET['act']=='getCity') {
$query_city = "SELECT DISTINCT city FROM rates ORDER BY city ASC";
$city = mysql_query($query_city, $db) or die(mysql_error() ." " .$query_city);
$row_city = mysql_fetch_assoc($city);
//$totalRows_groups = mysql_num_rows($groups);
$options[] = "{optionValue: '', optionDisplay: 'Select a City...'}";
do {
$options[] = "{optionValue:'".$row_city['city']."', optionDisplay: '".htmlentities(trim($row_city['city'])) ."'}";
} while ($row_city = mysql_fetch_assoc($city));

// print_r($options);
$theOptions = implode(",", $options);
$theOptions = "[".$theOptions."]";

echo $theOptions;

}


if ($_GET['act']=='getZip') {
$query_zip = sprintf("SELECT zipcode FROM rates WHERE city = '%s' ORDER BY zipcode ASC",$_GET['city']);
$zip = mysql_query($query_zip, $db) or die(mysql_error() ." " .$query_zip);
$row_zip = mysql_fetch_assoc($zip);
//$totalRows_groups = mysql_num_rows($groups);
$options[] = "{optionValue: '', optionDisplay: 'Select a Zipcode...'}";
do {
$options[] = "{optionValue:'".$row_zip['zipcode']."', optionDisplay: '".htmlentities(trim($row_zip['zipcode'])) ."'}";
} while ($row_zip = mysql_fetch_assoc($zip));

// print_r($options);
$theOptions = implode(",", $options);
$theOptions = "[".$theOptions."]";

echo $theOptions;

Thank you for your help!
Chilik

[NogDog]

Here's the above code in [php] tags, hopefully making it easier for myself and others to read it and then maybe help you:

if ($_GET['act']=='getCity') { 
    $query_city = "SELECT DISTINCT city FROM rates ORDER BY city ASC";
    $city = mysql_query($query_city, $db) or die(mysql_error() ." " .$query_city);
    $row_city = mysql_fetch_assoc($city);
    //$totalRows_groups = mysql_num_rows($groups);
    $options[] = "{optionValue: '', optionDisplay: 'Select a City...'}";    
    do {
        $options[] = "{optionValue:'".$row_city['city']."', optionDisplay: '".htmlentities(trim($row_city['city'])) ."'}";
    } while ($row_city = mysql_fetch_assoc($city));
    
//    print_r($options);
    $theOptions = implode(",", $options);
    $theOptions = "[".$theOptions."]";

    echo $theOptions;

}


if ($_GET['act']=='getZip') { 
    $query_zip = sprintf("SELECT zipcode FROM rates WHERE city = '%s' ORDER BY zipcode ASC",$_GET['city']);
    $zip = mysql_query($query_zip, $db) or die(mysql_error() ." " .$query_zip);
    $row_zip = mysql_fetch_assoc($zip);
    //$totalRows_groups = mysql_num_rows($groups);
    $options[] = "{optionValue: '', optionDisplay: 'Select a Zipcode...'}";    
    do {
        $options[] = "{optionValue:'".$row_zip['zipcode']."', optionDisplay: '".htmlentities(trim($row_zip['zipcode'])) ."'}";
    } while ($row_zip = mysql_fetch_assoc($zip));
    
//    print_r($options);
    $theOptions = implode(",", $options);
    $theOptions = "[".$theOptions."]";

    echo $theOptions; 

[NogDog]

You need to close the <option> tag with its closing ">" before the optionDisplay call.

[chilik]

Thanks Guys,
I've tried to re saved the PHP files and replaced them on the server and it started functioning again, I've posted "for the time being" because I had this phenomenon earlier and it stopped functioning after a while... I'm hoping that it will last now.

Thank you for willing to help me!
Have a nice day!
Chilik