|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 10th, 2000, 12:18 AM
|
|||
|
|||
|
Hello.
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? Thanks yoshi datera@datera.com http://www.datera.com
|
|
#2
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...
|
|
#3
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. yoshi datera@datera.com http://www.datera.com
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > searching 2 tables on one page? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
