多表搜索 [英] Multiple Table Search

问题描述

我有一个使用PHP和mysql的基本搜索功能，任何人都可以帮我制作一个单一搜索条件并搜索多个表并将不同结果反馈给用户的函数吗？

解决方案

我相信我们可以提供帮助。但是，我们不会为您编写，而是帮助您修复自己的代码。请发布有问题的代码和任何相关的其他代码段。还包括对正在发生的事情的详细描述，以及应该发生的事情。

@ziycon


你明白了吗？需要哪些表来搜索或搜索数据库中的所有表

您可以使用JOIN，但我不太确定您的问题的具体细节。阐述？

I have a basic search function working with PHP and mysql, can anyone help me to make a function that takes a single search criteria and searches multiple tables and gives the different results back to the user??

解决方案

I''m sure we can help. We however will not write it for you, but rather help you fix your own code. Please post the code in question and any relavent other snippets. Also include a detailed description of what is happening, and what should be happening that is not.

@ziycon
Are u clear on to which tables to search or search all tables in a DB is needed

You could use a JOIN, but I''m not quite sure on the specifics of your problem. Elaborate?

这篇关于多表搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！