Ordering my search results

[Ri1es]

Hi,
At the moment my member search works, however when I search for a member called 'Will' it gives the result 'Sam' first because in his biography he has the work Will, and he is above Will in the MySQL table. Is there a way to give the results that usernames match first, then the results that the biographies match. Here is a link t my search bar: http://www.blu-byte.co.cc/members/search/quick.php/. Try searching for Will, you will see what I mean.

Here is my current search code:

PHP Code: [Select]


$searchqu = mysql_query("SELECT * FROM $tbl_name WHERE usr OR bio LIKE '%$search%'");

//Draw table titles

echo "<table border='1' cellpadding='5' cellspacing='1' style='width: 75%' >";
echo "<tbody>";

echo "<tr>";
echo "<td>";
echo "<p><span style='font-family:tahoma,geneva,sans-serif;'><span style='font-size:20px'> Name </span></span></p>";
echo "</td>";
echo "<td>";
echo "<p><span style='font-family:tahoma,geneva,sans-serif;'><span style='font-size:20px'> Biography </span></span></p>";
echo "</td>";
echo "</tr>";

while($rows = mysql_fetch_array($searchqu))
{

$usr = $rows['usr'];
$bio = $rows['bio'];

if ($usr)
{

echo "<tr>";
echo "<td>";
echo "<p><span style='font-family:tahoma,geneva,sans-serif;'><strong> $usr </strong></span></p>";
echo "</td>";
echo "<td>";
echo "<p><span style='font-family:tahoma,geneva,sans-serif;'> $bio </span></p>";
echo "</td>";
echo "</tr>";

}
else
{

echo "<p><span style='font-family:tahoma,geneva,sans-serif;'>Sorry but we weren't able to find any members for the search $search.</span></p>";

}

}

echo "</tbody>";
echo "</table>";

}


Many thanks in advance.

[Ri1es]

Anyone?

[Noodles]

can you do it by ORDER BY usr

[Ri1es]

I will give that a go!

[Ri1es]

Just tried it and there has been no affect, could you please show me where you would put the ORDER BY, I might have positioned it wrongly!

Thanks in advance! 

[Noodles]

You would use in in the mysql query

$searchqu = mysql_query("SELECT * FROM $tbl_name WHERE usr OR bio LIKE '%$search%' ORDERBY usr");


Or maybe you could use ksort() function in php

[Ri1es]

Are you sure? Wouldn't there be a space?
$searchqu = mysql_query("SELECT * FROM $tbl_name WHERE usr OR bio LIKE '%$search%' ORDER BY usr");
The above code has no affect.
Thanks.

[Ri1es]

Ah the sort function? Could you implement that in to my code? It would be a big help.
Thanks.

[Noodles]

sorry ORDER BY does have a space in it maybe put ASC or  DESC

ORDER BY usr ASC

Thinking about it I cannot think how you could sort
with php because how would it know the search word ?

You would need the searched word and then use that to sort by otherwise it would ASC, DESC, key

but you have to give me anything more than a result from your search.

But you could try

PHP Code: [Select]

 
$usr = ksort($rows['usr']);
$bio = ksort($rows['bio']);

[Ri1es]

To get the searched word wouldn't you just use the variable $search, $search is equal to $_POST['Seach'] from a form.
Is that any help?

Thanks for your time, it is a great help!

[Noodles]

Try this query

PHP Code: [Select]

$searchqu = mysql_query("SELECT * FROM $tbl_name WHERE usr OR bio LIKE '%$search%' ORDER BY usr LIKE '%$search%' DESC");

[Ri1es]

Thanks, trying it now!

I have one other query. How would I duplicate a file named 'profile.php' to a specific directory, then renaming it.

Thanks for all your help, credit will be given.

[Noodles]

You can also try there are so many different sort() functions

sort($searchqu);

[Ri1es]

The other one works! Well I am glad I have got that one cleared up! Could you help me with that other problem?

How would I duplicate a file named 'profile.php' to a specific directory, then renaming it.

Thanks so much!

Is there anything I can do for you?

[Ri1es]

There is only one problem. When I search for users that don't have their names in their biography they don't show up?

Thanks