2. PHPRunner General questions
  3. Searching hte entire database?
This topic is locked

Searching hte entire database?

 		6/29/2006 16:51:03
PHPRunner General questions
A
 amirgulamali author

I am not sure if this can be done .. any idea or suggestions would really be appreciated...
Can a keyword be searched in all the tables simultaneously? if yes do the tables need to be linked? and if yes any effecient approach?
Thanx

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2902&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
J
 		Jane 6/30/2006

Hi,
theoretically you can join all your tables in the new query or view and then search keywords in it. Use Join statement for this purpose.

Read more info here:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
A
 		amirgulamali author 6/30/2006

Hi,

theoretically you can join all your tables in the new query or view and then search keywords in it. Use Join statement for this purpose.

Read more info here:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm


i have 4 tables...

  1. all products (includes everything)
  2. men's wear
  3. women's wear
  4. deals
    I want to have a column in the "all products" table where the item is found
    for instance
    ALL PRODUCTS

    **

    | ID | Product | Currently in |

    **

    | 01 | Jeans | Men's Wear |

    | 02 | Top | Women's Wear |

    | 03 | shirt | Men's Wear |

    | 04 | suit | deals |

    **
    Can join be used in this case?