How to search query in php?

Question

The error is that the program fails to search keyword.

Here is the following code:

 $query = "SELECT english.word, maranao.word, maranao.pronounciation, maranao.grammar, english.definition" . 
                "FROM english, maranao".
                "WHERE english.keyword_num = maranao.keyword_num and english.word = '$search'";

                $result = mysql_query($query) or die(mysql_error());

                while($row=mysql_fetch_array($result))
                {   
                    echo $row['word'];
                    echo $row['pronounciation'];
                    echo $row['grammar'];
                    echo $row['definition'];
                }

[**Please, don't use `mysql_*` functions in new code**](http://bit.ly/phpmsql). They are no longer maintained [and are officially deprecated](http://j.mp/XqV7Lp). Learn about [*prepared statements*](http://j.mp/T9hLWi) instead, and use [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli) - [this article](http://j.mp/QEx8IB) will help you decide which. If you choose PDO, [here is a good tutorial](http://j.mp/PoWehJ). — , Aug 11 '15 at 10:48

score 2 · Answer 1 · edited May 23 '17 at 12:07

2

You need space in your WHERE and FROM clause

" FROM english, maranao".

" WHERE english.keyword_num = maranao.keyword_num and english.word = '$search'";

And don't use mysql Why shouldn't I use mysql_* functions in PHP?

Try to learn Prepared statement

edited May 23 '17 at 12:07

Community

1
1

answered Aug 11 '15 at 10:48

Saty

22,443
7
33
51

this query is space sensitive. Thank you for your help. – Jude Howell Sarabia Aug 11 '15 at 10:53
1

@Judo100 if this answer is useful to you don't forget to accept it!!1 – Saty Aug 11 '15 at 10:58

How to search query in php?

1 Answers1