2. PHPRunner General questions
  3. Bug with Search For:?
This topic is locked

Bug with Search For:?

 		2/12/2008 9:06:41 PM
PHPRunner General questions
B
 BackyardArt author

I have the following tables in a MySQL Database:
Artists

ID - Name

Artwork

ID - Artist ID - Name - Date
Where Artist ID in the artwork table is the ID # of the artist (fkey)... I have phprunner do LookUp Wizard -> Lookup Table and have it autocomplete the artists name and display the artists name but the link field is the ID.
Here's my question. If I goto the artwork table and try to search for an artist name nothing appears. I'm not sure if this is a bug or a feature, but is there a work around so that if I use Search For and type in the artist's name I'll get a list of his artwork?
thanks in advance,
Dez
J
 		Jane 2/13/2008

Dez,
you can do the following:

  1. edit your SQL query on the Edit SQL query page.

    Here is a sample:
    select `Artwork`.`ID`,

    `Artist ID`,

    `Artists`.`Name`,

    `Artwork`.`Name`,

    `Date`

    from `Artwork` inner join `Artists`

    on (`Artwork`.`Artist ID`=`Artists`.`ID`)


2. Then check off `Artists`.`Name` field on the list and search pages only on the Choose fields tab.