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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php