youlichika — 2010-10-26T18:18:25-04:00 — #1
$db = mysql_connect("localhost","root","root") or dir("can not connect Mysql Server");
mysql_select_db("mydb",$db) or dir("can not connect Mysql Server");
I have many tables under mydb. They all have the same field names.
" id, name, detail, date". The table name is from table001 - table121.
How to make a MySQL Multiple Table query with short code and high efficient? Thanks.
(Apache/2.2.13 , PHP/5.2.11, MySQL 5.0.51a)
anotherdeveloper — 2010-10-26T18:36:55-04:00 — #2
What do you want the query to do? Or to put it a better way, what data do you want to collect and what do you want to do with it?
youlichika — 2010-10-26T18:58:16-04:00 — #3
hello, I want do a simple php intranet search. I do not want to write a long long query code.
These tables are some Books directory. book name, book introduction and added date.
r937 — 2010-10-26T19:56:31-04:00 — #4
that's going to be a huge problem
really, is there any chance you can combine them into one table?
what was the idea behind separate tables?
youlichika — 2010-10-27T05:01:37-04:00 — #5
Hi r937, each table is one Book directory: such as science, culture, science fiction...
If conbain them, it also will be a big project...
r937 — 2010-10-27T05:18:12-04:00 — #6
they should definitely be combined