justageek
msg:3270733 | 4:17 pm on Mar 4, 2007 (gmt 0) |
You can do it but it not always easy. If you use something like: select * from db order by substring_index(`db`.`column`,' ',-1) That will give you what you want. The problem though is that it may take a long time if you have a lot of records. If we could use the substring_index to create an index it would be fast but we can't. So, if you have a lot of records then use the substring_index to populate another field at insert time that holds the last word and then index that field and do the sort it should be fast and give you what you want. JAG
|
sabai
msg:3270780 | 5:58 pm on Mar 4, 2007 (gmt 0) |
Or you could do it in PHP... assuming you have selected what you want from the DB. Write a function that compares two strings and use the "usort" php function. This will do what you want... look up usort in the PHP manual to see how to go about doing this.
|
jake66
msg:3273483 | 3:45 am on Mar 7, 2007 (gmt 0) |
thank you both for the suggestions. i've tried usort, but it was a bit above my head.
i took a stab at justageek's suggestion and got it to work :) dealing with the same question.. now that i have my ouput sorted the way i wanted it, is it possible to insert a break or:
<br> between each different sort term (the word that defines what's being sorted)? for instance.. presently my list looks like this:
Black n Blue Widget
Sparky Blue Widget
Black Widget with Smells
Purple Widget that Smells
Green Widget with Wings can i make it output like:
Black n Blue Widget
Sparky Blue Widget
--break here--
Black Widget with Smells
Purple Widget that Smells
--break here--
Green Widget with Wings
|
justageek
msg:3274008 | 3:30 pm on Mar 7, 2007 (gmt 0) |
If you have the last word in its own column then just add a condition in your loop. Something like: $current_word = false;
$data_output = "";
while($row = mysql_fetch_assoc($rs)){
if($current_word and ($row['word'] <> $current_word)){
$data_output .= "<br>";
$current_word = $row['word'];
}
do the rest of what you have in the loop now
} JAG
|
jake66
msg:3291436 | 9:23 pm on Mar 23, 2007 (gmt 0) |
thank you everybody! :) now i would like to do the same thing, but order the results AFTER a -
(dash) i don't think it's feasible to do a count by characters, like the script mentioned in this topic, because all of my results have varying character counts, but the majority that i want to sort have similar titles, after the - is this possible?
|
jake66
msg:3305353 | 2:31 am on Apr 8, 2007 (gmt 0) |
is it possible to combine this and an explode() function? if so, how could i structure the command?
|
|
