php - 如何在php中搜索查询？

Question

错误是程序无法搜索关键字。

下面是代码:

 $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'];
                }

Answer 1

您的 WHERE 和 FROM 子句中需要空格

" FROM english, maranao".

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

并且不要使用mysql Why shouldn't I use mysql_* functions in PHP?

尝试学习Prepared statement