Can someone help me understand the problem with the approach I am trying
or suggest a new approach?
Basic Objective: Search several fields of a table for keywords/search
terms and return the ID's for records containing those keywords. I would
like to then sort those ID's in descending order of the number of times
there is a match.
Approach: (Note: because my host has not updated My SQL, I cannot use
the Match function) I am searching each table field for each search term
then merging the resulting arrays. I then perform an
"array_count_values" on the final array to determine frequency, "rsort"
that to get descending order. See query function script after Problems.
Problems:
1) I get the following error message when the "array_count_values"
function is reached::
Can only count STRING and INTEGER values!
This is because the values in the array are also arrays but I don't
know how to convert them to the single values.
2) How do I reverse sort and convert the associative array that is
generated by "array_count_values" back to the ID's that have become
keys?
Query Funciton Example:
$test_array=Search_Titles($item);
$count_array=array_count_values($test_array);
function Search_Titles($item) {
//get candidates saved group preferences
$sql="SELECT CID FROM abbreviated WHERE CSkills like '% $item%'";
$result = @mysql_query($sql) or die("Couldn't execute title match
query.");
if (!$result)
return false;
$num_groups = @mysql_num_rows($result);
if ($num_groups ==0)
return false;
// create an array of groups
$result = db_result_to_array($result);
return $result;
}
Please reply to my email address as well as the newsgroup:
[EMAIL PROTECTED]
Thanks,
Rick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
