Re: [PHP] Can a range be passed to a query?

[Miller, Terion]

On 8/1/09 12:04 AM, "Paul M Foster" <pa...@quillandmouse.com> wrote:

$values = implode(',', $other);

For some reason no matter how I tried to get it to say # should pull anything 
that does not start with a letter.....
It pulls all restaurants....or it breaks the full script.
Here are all the things I have tried so far...

         //Create array with letters AND number sign                        
$letters = range('A','Z');                        array_push($letters, '#');    
                                            $menu = '';                        
$selectedLetter = isset($_GET['letter']) ? $_GET['letter'] : null;              
          foreach($letters as $letter) {                            $menu .= 
($letter == $selectedLetter)                              ? sprintf('%s&nbsp', 
$letter)                              : sprintf('<a 
href="browse.php?letter=%s">%s</a>&nbsp;', $letter, $letter);                   
     }    echo "<div align=\"center\"><b>{$menu}</b><br /></div>";              
                                                                                
        //Show all restaurants that start with $letter                          
                              $sql = "SELECT DISTINCT ID, name, address FROM 
restaurants WHERE name LIKE '{$selectedLetter}%'";                              
                       /*                                                       
 //Show all restaurants that start with $letter  not between "A" and "Z"        
                                                if ($selectedLetter == "#") {   
                                                         $a= "1";               
                                             $sql = "SELECT DISTINCT ID, name, 
address FROM restaurants WHERE name LIKE  '{$a}%'";                             
                                                                                
      }elseif ($selectedLetter == "#"){                                         
                  $a= "2";                                                      
      $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE name 
LIKE  '{$a}%'";                                                                 
                                                         }elseif 
($selectedLetter == "#"){                                                       
    $a= "3";                                                            $sql = 
"SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE  '{$a}%'";  
                                                                                
                                        }elseif ($selectedLetter == "#"){       
                                                    $a= "4";                    
                                        $sql = "SELECT DISTINCT ID, name, 
address FROM restaurants WHERE name LIKE  '{$a}%'";                             
                                                                                
          }elseif ($selectedLetter == "#"){                                     
                      $a= "5";                                                  
          $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE name 
LIKE  '{$a}%'";                                                                 
                                                        }elseif 
($selectedLetter == "#"){                                                       
    $a= "6";                                                            $sql = 
"SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE  '{$a}%'";  
                                                                                
                                       }elseif  ($selectedLetter == "#"){       
                                                    $a= "7";                    
                                        $sql = "SELECT DISTINCT ID, name, 
address FROM restaurants WHERE name LIKE  '{$a}%'";                             
                                 }elseif ($selectedLetter == "#"){              
                                             $a= "8";                           
                                 $sql = "SELECT DISTINCT ID, name, address FROM 
restaurants WHERE name LIKE  '{$a}%'";                                          
                    }elseif ($selectedLetter == "#"){                           
                                $a= "9";                                        
                    $sql = "SELECT DISTINCT ID, name, address FROM restaurants 
WHERE name LIKE  '{$a}%'";                                                      
                                                                    }else{      
                                                     $a= "0";                   
                                         $sql = "SELECT DISTINCT ID, name, 
address FROM restaurants WHERE name LIKE  '{$a}%'";                             
                                }                                               
        */                                                                      
                                                                                
                                                                                
        /*doesn't work returns all results for #                                
                                if ($selectedLetter == "#"){                    
                                            $other = range('0','9');            
                                                    $sql = "SELECT DISTINCT ID, 
name, address FROM restaurants WHERE name LIKE '{$other}%'";                    
                                                                                
                          }                                                     
                                                                if 
($selectedLetter =="#"){                                                        
    $other = ctype_digit(range('0','9'));                                       
                     $sql = "SELECT DISTINCT ID, name, address FROM restaurants 
WHERE name LIKE '{$other}%'";                                                   
       }                                                           */           
                                                                                
                                                                                
 // $sql = "SELECT DISTINCT ID, name, address FROM restaurants  left(name, 1) 
between 0 and 9";                                                         // 
$result = mysql_query($sql) or die(mysql_error());                              
                                                                                
                                                        if ($selectedLetter == 
"#"){                                                                $other = 
range('0','9');                                                                
$values = implode(',', $other);                                                 
               $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE 
name LIKE '{$values}%'";                                                        
                                                                      }         
                                                                                
                                                                                
                                                 /*//Show all restaurants that 
start with $selectedLetter                                                      
  if ($selectedLetter != "#") {                                                 
           //Letter was selected                                                
            $where = "name LIKE '%{$selectedLetter}'"                           
                             } else {                                           
                 //Number was selected                                          
                  $where = "SUBSTRING(name,1,1) IN ('" . implode("','", 
range(0,9)) . "')";                                                        }    
                                                                                
                            $sql = "SELECT DISTINCT ID, name, address FROM 
restaurants WHERE $where";                                                      
  $result = mysql_query($sql) or die(mysql_error());                            
                                                                                
    while($row = mysql_fetch_assoc($result)){                                   
                         $name = $row['name'];                                  
                          printf('<a href="view.php?ID=%s"><b>%s</b><br />%s<br 
/><br /></a>',                                                                  
 $row['ID'],                                                                    
 $row['name'],                                                                  
 $row['address']                                                            );  
                                                                                
                              }*/                                               
                                                               $result = 
mysql_query($sql) or die(mysql_error());

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php