Reg Expresion Help

[graham23s]

Hi Guys,

 

in my search function if a user searches for a file named:

 

something.somethinelse.pdf

 

the concatenation symbol seems to only allow the first word to be searched for, i was going to (if possible) use a reg expression to tell search to ignore the (.) is that possible at all?

 

if (eregi('.', $keywords)) {
    echo "if the string contains a (.) what to do?";
}

 

thanks guys

 

Graham

[chigley]

If your search code fails when it hits a period, you need to sort that out instead of finding a workaround! Paste your search code please

[graham23s]

Hi Chigley,

 

no problem mate here it is:

 

<?php
    // Check to see if there are submitted keywords...///////////////////////////////
    if (isset($_GET["keywords"]) && ($_GET["keywords"] != "")) {

	// Require a database connection...//////////////////////////////////////////////
	require("includes/db_connection.php");

	// Capture our search words and remove url encoding...///////////////////////////
	$keywords = urldecode($_GET["keywords"]);

	// Create our query, including our keywords...///////////////////////////////////
	$sql  = "SELECT id,file_name,cat_id,description,date_added ";
	$sql .= "FROM `uploaded_files` ";
	$sql .= "WHERE `file_name` LIKE '%$keywords%' OR `description` LIKE '%$keywords%'";
	$sql .= "ORDER BY `date_added` ASC ";

	// Create a result set from our query.../////////////////////////////////////////
	$rs = mysql_query($sql) or die(mysql_error());

	// number of results...//////////////////////////////////////////////////////////
	$num_res = mysql_num_rows($rs);
?>

 

thanks mate

 

Graham