 |  |  |  |  |  |  |  |
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 advanced apache api array autosuggest basics beginner broken cakephp class cms code combobox compression cron curl data database date datepart display dropdownlist dynamic email eregi error execution file files folder form forms function functions google head href htaccess html httppost if...loop image include includingmysecondfileinthechain ip javascript job joomla jquery js key library limit link login md5 menu mlm multiple mysql mysql_real_escape_string oop password paypal pdf pdfdownload php phpvotingscript problem procedure query random screen script search searchbox server session sessions smarty source space sql stored system table traffic tutorial unicode upload url variable video volume votedown web website youtube zend