First:
Use the SQL distinct command.. it's explained here:
http://www.mysql.com/doc/en/SELECT.html
That will get you unique values.
Then just loop through the result:
while ($d = mysql_fetch_assoc($return)) {
?><option value="<?=$d['value']?>"><?=$d['name']?></option>
<?
}
Second:
get the value from the other table into a variable, during each iteration of
the loop check to see if they match, if so add 'selected'.
while ($d = mysql_fetch_assoc($return)) {
?><option value="<?=$d['value']?>"<?
if ($other_table_value == $d['value'])
echo " selected";
?>><?=$d['name']?></option>
<?
}
Third:
If you're using MySQL, check this out:
http://www.mysql.com/doc/en/Fulltext_Search.html
If you're using something else, it's more complex I think. Someone may have an
elegant solution, but I would do something like:
// Get total number of keywords:
$numofkeywords = count(str_replace ( " ", " ", $keywords));
// Split up your search words:
$search = explode(" ", $keywords);
$total_matched = 0;
// loop through the array of search terms and get number of returns.
foreach ($search as $searchword) {
$total_matched += count(str_replace($searchword, $searchword, $keywords));
}
// echo out the result in percent. (to one decimal place even!)
echo "Percent Matched: ".round(($total_matched/$numofkeywords)*100), 1)." %";
I'm sure there's a better way to get a word count from a string, but it's
late.. I didn't try the above code, so I'm just guessing it works.. I think
it's the right idea though.
-Micah
On Mon October 27 2003 4:54 pm, Shannon Doyle wrote:
> Hi People,
>
> I have a three part question here. Well actually its 3 separate
> questions.
>
> First.
>
> How would I populate a select menu from a mysql databse with the entries
> from a particular field, but only showing those that are unique, ie not
> showing more than 1 of the same value.
>
> Second.
>
> How would I then have one of those options selected depending on what it
> contained in another table?
>
>
>
> Third.
>
> I need to understand how the following would be achieved.
>
> In the database there is a text field that contains a number of
> 'keywords' I need to be able to search through those individual keywords
> and return results based on a % match from the original search. Ie if I
> search for 'secretary, typing, customer relations' I need to return all
> records from the database that has one or all of those words contained
> in the text field and display them as a % match of that search, ie if 1
> match then 33% 2, 66% and so on.
>
> Any help on the above three would be fantastic.
>
> Cheers,
>
> Shannon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
