PhpDig.net - View Single Post

Not Logged In · 11-27-2003, 08:02 PM

I've been able to add a new field to 'sites', however I'm having problems linking to another table.

I added a field called account_id and when I enter a site for indexing I enter the ID of the account I already have.

What I want to do is pass more information to each result from my client DB. ex. sites.account_id = clients.id.

I've tried adding it to ' $query = "SELECT sites.site_url, sites.port, ' but to no avail.

I've also added my table to the config.php.

Any help would be great!

Thanks!

11-27-2003, 08:02 PM	#1
Not Logged In Green Mole Join Date: Nov 2003 Posts: 5	Link to another table I've been able to add a new field to 'sites', however I'm having problems linking to another table. I added a field called account_id and when I enter a site for indexing I enter the ID of the account I already have. What I want to do is pass more information to each result from my client DB. ex. sites.account_id = clients.id. I've tried adding it to ' $query = "SELECT sites.site_url, sites.port, ' but to no avail. I've also added my table to the config.php. Any help would be great! Thanks!