Can a range be passed to a query?
| From: | Miller, Terion | Date: | Fri, 31 Jul 2009 21:24:45 +0000 |
| Subject: | Can a range be passed to a query? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-296147@lists.php.net to get a copy of this message | ||
I'm still struggling with using ranges... Can they be passed to a query
somehow...
I have this so far but it pulls nothing:
//Show all with $letter not between "A" and "Z"
if ($selectedLetter = "#") {
$other = range('0','9');
$sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE
'$other'";
$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']
);
}