Re: Select from 24 tables

Dave Carrera wrote:

Hi List, How do I select data from 24 table in my database. Each one is identical in structure layout being Id,name,list I want to select where like $_POST[var] from a form all of the tables but I am having trouble :( I thought making a var string like $string = "table1,table2,table3,....."; And doing (select * from $string where list like \"%$_POST[var]%\"); Would work but I get a MySql error which say "Column: 'list' in where clause is ambiguous" I am stumped so I ask the list for help or advise please. Any advise is very much appreciated and I thank you in advance for any help or pointers. Thank you Dave C

SELECT * FROM dbname.table1, dbname.table2, dbname.table3, ...etc WHERE table1.list LIKE '%$_POST['var']%', table2.list LIKE '%$_POST['var']%', table2.list LIKE '%$_POST['var']%', ...etc -- By-Tor.com It's all about the Rush http://www.by-tor.com