Jump to content

Archived

This topic is now archived and is closed to further replies.

corillo181

[SOLVED] 2database

Recommended Posts

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..?

Share this post


Link to post
Share on other sites
if you do use two tables you could do it this way:

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

Share this post


Link to post
Share on other sites
that kind thing i was looking for.. but i'm trying the other way you told me first seens easier..

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.