 |  |  |  |  |  |  |  |
Rank mysql search results by coulmn weighting
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: May 2009
Posts: 81
Reputation: 
Solved Threads: 0
Junior Poster in Training
Hello everybody,
how do I rank mysql search results by column weighting?
thanks for your input.
how do I rank mysql search results by column weighting?
thanks for your input.
•
•
Join Date: Mar 2008
Posts: 61
Reputation:
Solved Threads: 11
Junior Poster in Training
what do you mean by column weighting?
If you want to choose a preference you just do
changing column_1 etc to whatever field you want to order by. You can order by more then one and you can do descending(DESC) or ascending(ASC) order
If you want to choose a preference you just do
PHP Syntax (Toggle Plain Text)
•
•
Join Date: May 2009
Posts: 81
Reputation:
Solved Threads: 0
Junior Poster in Training
Hi Tommy,
I have several columns in my table 'plan'.
they are ability, noofstudents etc...every column has been weighted according to theirimportance/relevance in planning.
for example: ability: 075
motivation: 0.25
it is not an article search. it is a record search from a table.
thanks in advance.
I have several columns in my table 'plan'.
they are ability, noofstudents etc...every column has been weighted according to theirimportance/relevance in planning.
for example: ability: 075
motivation: 0.25
it is not an article search. it is a record search from a table.
thanks in advance.
please try to ellaborate more on column weighting i cant really understand the exact meaning of the word.
Last edited by denit; Jun 23rd, 2009 at 2:44 pm. Reason: wasnt clear
•
•
Join Date: Mar 2008
Posts: 61
Reputation:
Solved Threads: 11
Junior Poster in Training
just do where weight_filter is the name of the column with that number in
PHP Syntax (Toggle Plain Text)
•
•
Join Date: May 2009
Posts: 81
Reputation:
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by denit 
please try to ellaborate more on column weighting i cant really understand the exact meaning of the word.
What I intend to do is..
1. Instead of just list the search result..the percentage of how similar /match the keyword and the record will be displayed..
2. this percentage is based on how important those elements/column..say ability:1, motivation:0.75.
If it is not clear..I will explain in more detail..
MAny thanks
|
Similar Threads
- How can we do the Pagination of Search Results. (PHP)
- GKey - Google Ads 1 to 10 on the search results first (Website Reviews)
- MySQL Search - Google like? (PHP)
- pagination of mysql query results (PHP)
- How to hyperlink mysql search results? (MySQL)
- Mysql Search results (MySQL)
- search and results problem (PHP)
- Folders open Search Results (Windows NT / 2000 / XP)
- See your Website in Google search results in 24h (Post your Resume)
Other Threads in the PHP Forum
- Previous Thread: Including External Files
- Next Thread: User Authentication multiple user types
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
.htaccess alerts apache api archive array autocomplete beginner binary broken cakephp checkbox class cms code convert cron curl database dataentry date display duplicates dynamic echo email emptydisplayvalue error execute explodefunction file files firstoptioninphpdroplist folder form forms function functions google hack href htaccess html htmlspecialchars image include insert ip javasciptvalidation javascript joomla keywords limit link login mail matching menu methods mlm multiple mysql network object oop paypal pdf php problem query radio random recursion recursive redirect remote script search securephp server sessions shot sms source space sql subscription syntax system table tutorial tutorials update upload url validator variable video web youtube
