 |  |  |  |  |  |  |  |
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
301 access apache api array beginner binary broken button cakephp checkbox class clean cms code countingeverycharactersfromastring crack cron curl database date decode directory display dissertation dropdown dynamic echo email error fairness file files folder form forms function functions google href htaccess html image include insert integration ip javascript joomla limit link login mail match md5 menu methods mlm multiple mysql newsletters oop pageing pagerank paypal pdf php problem protocol query radio random recursion remote script search secure server sessions simple sms soap source space spam sql syntax system table tutorial update upload url validator variable video virus votedown web youtube
