Can get record to display correct

[joefox]

I still cant seem to get this to work right.

If there is only 1 result, i wanted it to redirect to the redirecturl, in my datbase, if there are no reults, then diplay "NO RESULTS"
and if there are more then 1 result, loop through and display them out.

<?php
  if($_SERVER['REQUEST_METHOD'] == "POST"){ 
   require_once ('connect.php'); 
  require_once ('opendb.php'); 
  
  $zipcode = $_POST['zipcode_entered_search']; 
    
  $query = "SELECT * FROM zipcodes WHERE zipcode='$zipcode'"; 
  $result = @mysql_query ($query); 
  $count = mysql_num_rows($result); //number of results 

  if ($count == 0){ 
    echo "No localtions are found"; 
  }else if($count == 1){ 
    //redirect
  }else if($count > 1){

    echo "<b>Located $count result(s)</b><br />"; 
    while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ 
       echo $row['company_name'] . '<br>' .'<a href="'. $row['redirect_url'] . '"> Visit Website </a>'. ' '  .'<br>' . $row['notes_1'] . '<p>'; 
    } 
    } 
  }
  }else{ 
    // nothing
  } 
?>

[asterix299]

try removing the @ from mysql_query.

edit:

also, is zipcode stored in your database as a varchar or an integer? If it's stored as an integer you should remove the single quotes around $zipcode in your query.

[joefox]

its stored as a varchar.

I tried to remove the @ in front, and it always displays "no records found"

[asterix299]

well my only other idea is that there's something wrong with the table in the dbase... try deleting it and remaking it.

[joefox]

Its something with my if/else's

It works fine before i add another else if

[asterix299]

I'm pretty sure this doesn't matter but I've never made my else if's two words. I'm not sure if php differentiates between the two but try making it elseif rather than else if.

[joefox]

the if elses were working right, its just when i added another if else to the mix.

[joefox]

also, the part where if it finds 1 result, its not redirecting to the URL