PHP and Mysql select query issue

Question

Well im working on a small php script and i made a query to connect to db like this:

$id = mysql_real_escape_string(strip_tags($_POST['keyword']));
$query = mysql_query("select * from kalimat WHERE name LIKE '%$id%' OR content like '%$id%'");
while($row=mysql_fetch_assoc($query))
{
    echo "<a href='interpretation-".$row['id'].".html'><li>".$row['name']."</li></a>";
}

Now i want to echo the result of select from names then echo the result of selecting from content thank you in advance.

Please do not use the mysql_ functions, theyre deprecated. Use mysqli instead — LionC
– LionC, Commented Jul 3, 2014 at 10:20
I'm not sure I understand what you are trying to do? Do you want to make new select statements or just check which of the results matched on name and which on content? Maybe use an if statement to check if name or content matches? — aniri
– aniri, Commented Jul 3, 2014 at 10:20
@aniri the current querry show me result in random order i want to show the records that match the name then the records than match the content — user3756377
– user3756377, Commented Jul 3, 2014 at 10:21

echo_Me · Accepted Answer · 2014-07-03 10:25:01Z

2

Try that

   select * from kalimat WHERE name LIKE '%$id%' OR content like '%$id%'
   order by  CASE WHEN name    LIKE '%$id%' THEN 0
                  WHEN content LIKE '%$id%' THEN 1 END

answered Jul 3, 2014 at 10:25

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP and Mysql select query issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related