using url to split query

Anon

The following code will take a url such as test.php?alpha=r-t and return all entries starting with R or T.

Does anyone know how I can make it return all entries starting with R THRU T ?

Chad

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$letter = split("-", $alpha);

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR product_description LIKE '$letter[1]%'");

$letter[0]; // first letter (a)
$letter[1]; // second letter (d)

echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
echo "<tr>\n";
echo "<td style=\"background-color: #000;\"><table cellpadding=\"2\" cellspacing=\"1\" border=\"0\">\n";
echo "<tr>\n";
echo "<th>NDC#</th>\n";
echo "<th>Product Description</th>\n";
echo "<th>Package Size</th>\n";
echo "<th>Compare To</th>\n";
echo "</tr>\n";

while($row = mysql_fetch_array($query))

echo $row [ printf("
<tr valign=\"top\">\n
<td class=\"data\" nowrap>%s</td>\n
<td class=\"data\">%s</td>\n
<td class=\"data\">%s</td>\n
<td class=\"data\">%s</td>\n
</tr>\n", $row["ndc"], $row["product_description"], $row["size"], $row["compare"])];

}
echo "</table>\n";

//?>

Anon

"SELECT * FROM products WHERE substr(product_description, 0, 1) >= '$letter[0]' AND substr(product_description, 0, 1) <= '$letter[1]'"

cordex

So much better then my solution. Again. Still, mine is capable of telling you which letters it is searching.

$alphabet_st = "abcdefghijklmnopqrstuvwxyz";
$var1 = strtolower($letter[0]);
$var2 = strtolower($letter[1]);
if($var1 < $var2) $selected_st = substr($alphabet_st, strpos($alphabet_st,$var1), (strpos($alphabet_st,$var2)-strpos($alphabet_st,$var1)+1));
else $selected_st = substr($alphabet_st, strpos($alphabet_st,$var2), (strpos($alphabet_st,$var1)-strpos($alphabet_st,$var2)+1));
$query_st = "SELECT * FROM products WHERE product_description LIKE '".$selected_st[0]."%'";
for($i=1;$i<strlen($selected_st);$i++)
$query_st .= "OR product_description LIKE '".$selected_st[$i]."%'";
$query_rs = mysql_query($query_st);

Anon

I'm going to kick myself when I finally get this. I did just as you said. I even did it when you said it on friday and i'm still getting this error.

Is there any logical reason that is shouldn't work. The error is near --- while($row = mysql_fetch_array($query))

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$letter = split("-", $alpha);

$query = mysql_query("SELECT * FROM products WHERE substr(product_description, 0, 1) >= '$letter[0]' AND substr(product_description, 0, 1) <= '$letter[1]'");

$letter[0]; // first letter (a)
$letter[1]; // second letter (d)

while($row = mysql_fetch_array($query))

}
echo "</table>\n";

//?>

cordex

Try changing this:

{
while($row = mysql_fetch_array($query))

to this:

while($row = mysql_fetch_array($query))
{

Anon

Already tried that. No luck there either.

hmmmmm. Same error