[SOLVED] 2database

[corillo181]

ok.. lets say i got 2 database..

one is for comments..

and another one for pictures..

what i'm trying to do is finding a way to assigne comment to a picture..

i was thinking about..

in the comment data base put a field with the name picname.. and in php assign the pic name to the comment..
like lets say..

$sql1= 'select name from pic';
$sql2='select name from comment';

insert into comment(picname,comment) values($picname,$comment)..

i just did somethin quick i'm just triyng to give a illustration..

my question is if everytime they view the picture will the be able to see the comment with such a simple comment books..

like when they viee the picture it will have..

select from commet where pic=$picname

.. will the be possible or there is some other way of joining 2 database that would make it easier..?

[michaellunsford]

why not just have one table for both?

[corillo181]

oh.. never thought about it that way.. i gues slet me give it a try..

[michaellunsford]

if you do use two tables you could do it this way:

SELECT * FROM `comment`,`pic` WHERE `pic`.`name` = `comment`.`name`

[corillo181]

that kind thing i was looking for.. but i'm trying the other way you told me first seens easier..