July 10th, 2000, 12:18 AM
I am attempting to search 2 different tables on a single page (through perl). However, the second table NEVER returns results. Will perl & MySQL only search a single table at a time? Can I get around this?
July 11th, 2000, 08:52 AM
when you issue your queries the table is specified (eg 'select * from TABLE') so there is no problem selecting from any number of tables on a single page, in fact you can query as many seperate tables and databases in not only a single page but a single query as well (using joins).
so i am not sure where your difficulty lies... are you preparing the second query correctly? are you executing it? where are you putting the results and how are you getting them back to output into html?
I'd check your query first though, try it on the command line, see if that works...
July 11th, 2000, 05:57 PM
I figured it out.. thanks!
I realized that I did not have any data in the second table - haha.