corillo181 Posted May 5, 2006 Share Posted May 5, 2006 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..? Link to comment https://forums.phpfreaks.com/topic/9145-solved-2database/ Share on other sites More sharing options...
michaellunsford Posted May 5, 2006 Share Posted May 5, 2006 why not just have one table for both? Link to comment https://forums.phpfreaks.com/topic/9145-solved-2database/#findComment-33669 Share on other sites More sharing options...
corillo181 Posted May 5, 2006 Author Share Posted May 5, 2006 oh.. never thought about it that way.. i gues slet me give it a try.. Link to comment https://forums.phpfreaks.com/topic/9145-solved-2database/#findComment-33670 Share on other sites More sharing options...
michaellunsford Posted May 5, 2006 Share Posted May 5, 2006 if you do use two tables you could do it this way:SELECT * FROM `comment`,`pic` WHERE `pic`.`name` = `comment`.`name` Link to comment https://forums.phpfreaks.com/topic/9145-solved-2database/#findComment-33672 Share on other sites More sharing options...
corillo181 Posted May 5, 2006 Author Share Posted May 5, 2006 that kind thing i was looking for.. but i'm trying the other way you told me first seens easier.. Link to comment https://forums.phpfreaks.com/topic/9145-solved-2database/#findComment-33675 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.