sql_regcase

Anon

Hi everyone I am trying to use sql_regcase and well it seems not to be playing nice.

I have the following code I am trying to do a case sensitive search on filename. What am I doing wrong???

<?php
$dbcnx = @mysql_connect("localhost", "ya", "right");
mysql_select_db('test');

$select = "Select id, date, case_num, name, filename, filelocation";
$from = " From d";
$where = " Where id > 0";
$order = " Order by date DESC";
$limit = " Limit $limit";
if ($name != "") {
$where .= " and name='$name'";
}
if ($date != "") {
$where .= " and date='$date'";
}

if ($filename != "") {
$filename = sql_regcase('$filename');
$where .= " and filename LIKE '%$filename%'";
}
<TABLE width="100%"BORDER="1">
<TR>
<TH>Date</TH>
<TH>Case Number</th>
<th>Case Name</TH>
</TR>

<?php

$result = mysql_query($select . $from . $where . $order . $limit);
if (!$result) {
echo("</TABLE>");
echo("Error retrieving employee's from database! ".
"Error: " . mysql_error());
exit();
}
$number=mysql_numrows($result);

while ($r = mysql_fetch_array($result)) {
echo("<TR>\n");
$date = $r["date"];
$case_num = $r["case_num"];
$filename = $r["filename"];

echo("<TD>$date</TD>\n");
echo("<td>$case_num</td>\n");
echo("<td><a href='" . $r["filelocation"] . "'>" . $r["filename"] ."</td>\n");
echo("</tr>\n");
}

?>
</table>
<?php
if ($number ==0) {
echo("Your search did not return any results <a href=d.php3>Please
click hear to try again.</a>");
}
?>

rrijnders

Try changing

$filename = sql_regcase('$filename');

$filename = sql_regcase("$filename");

I have a feeling the single quotes are keeping $filename from dereferencing the variable; you are sql_regcase()ing '$filename' as a literal.

-- Rich

Anon

Richard--

That was a problem but not the total answer...I actually stumbled on that last night....I put some echo statments in to see what the varibles looked like but still the query only brings back the exact case.....it is probably something so stupid like a sytax error that I am just missing.....but it is driving me nuts....

Thanks for your response

rrijnders

Well, I don't know if you can actually use regular expression syntax inside a LIKE statement; never done that before. Usually when I want to perform a case insensitve search on a DB field, I just convert both comparison values to lower case like:

$value = strtolower($someval);
$sql = "SELECT * FROM myTable WHERE name=strtolower('$value')";

Try doing your comparison that way, might work better for you.

-- Rich Rijnders
-- Irvine, CA US