 | | |
|
esq
User
Sep 23, 2003, 10:50 PM
Post #1 of 2
(2122 views)
Shortcut
|
A php + mysql problem...
|
Can't Post
|
|
Hi!
I´m building a site with php and mysql. And now at the very end I´m puzzled. Let me explain;
I´m using DGS search as a search engine and now I´m trying to configure it to search two tables at the mysql database. All I get is this error: 'id' in field list is ambiguous
I know that it has something to do with this setup property:
$database[0]['table'] = array('perus', 'uutiset'); /* The table in database to search. */
$database[0]['tableAssoc'] = ''; /* If multiple tables listed, is used to join the tables. See INSTALL. */
$database[0]['searchField'] = array('id', 'nimi', 'kaupunki', 'postin', 'puh', 'fax', 'email', 'www', 'auki', 'JUTTU', 'otsikko'); /* The fields to search. */
$database[0]['returnField'] = array('id', 'nimi', 'kaupunki', 'postin', 'puh', 'fax', 'email', 'www', 'auki', 'JUTTU', 'otsikko'); /* Fields returned from db. Can be used to sub into link, url and desc. */
And the $database[0]['tableAssoc'] = ''; , is the place to what I should do something (I think) but I just cant figure out what on earth I should be putting there...
All the help is more than appriciated.
Thanx in advance ;0)
Esq
P.S. I attached the install text if that could help you to solve the prob, because my brain capacity cant figure this one out *LOL*
(This post was edited by esq on Sep 23, 2003, 10:51 PM)
|
|
Attachments:
|
INSTALL.
(30.5 KB)
|
|
| |
|
esq
User
Sep 24, 2003, 5:23 AM
Post #2 of 2
(2116 views)
Shortcut
|
Re: [esq] A php + mysql problem...
[In reply to]
|
Can't Post
|
|
No problem!!! *yesh* I got the problem solved
- esq -
|
|
| |
|
