#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    35
    Rep Power
    14
    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...
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    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

Similar Threads

  1. submitting from a child page to it's parent page
    By equalize in forum HTML Programming
    Replies: 4
    Last Post: December 3rd, 2003, 09:23 PM
  2. searching multiple tables from multiple dropdowns
    By JimB1 in forum PHP Development
    Replies: 2
    Last Post: July 16th, 2003, 06:16 AM
  3. searching two tables
    By Gerhard in forum PHP Development
    Replies: 2
    Last Post: July 11th, 2002, 05:20 PM
  4. passing form variables from page 1 to 3
    By davaby in forum PHP Development
    Replies: 4
    Last Post: June 19th, 2002, 03:22 PM
  5. Searching two tables one query
    By Marky_Mark in forum MySQL Help
    Replies: 6
    Last Post: February 11th, 2002, 10:07 AM

IMN logo majestic logo threadwatch logo seochat tools logo