hi!!
is there any method to join 2 mysql tables..
i m thinking to make a gallery page and i think for the gallery i need to tables and it may need to join both tables....
is there any way to make simple gallery script with mysql backend?
Help me guys..... i am a simple php coder(not a professional)....
please......
i will be very grateful to you...
thanks in advance..
join table??
Moderator: General Moderators
- allspiritseve
- DevNet Resident
- Posts: 1174
- Joined: Thu Mar 06, 2008 8:23 am
- Location: Ann Arbor, MI (USA)
Re: join table??
This is more of a mysql question than a php apps question...kanchan wrote:hi!!
is there any method to join 2 mysql tables..
i m thinking to make a gallery page and i think for the gallery i need to tables and it may need to join both tables....
is there any way to make simple gallery script with mysql backend?
Help me guys..... i am a simple php coder(not a professional)....
please......
i will be very grateful to you...
thanks in advance..
You can do a join like this:
Code: Select all
SELECT * FROM table1 INNER JOIN table2 ON (table1.field = table2.field)Good luck,
Cory
Re: join table??
All of relational database design is based on joining tables, but the real issue is understanding how to design tables and why you need to join them. It is not a matter of "I think I need 2 tables", it is the result of careful relational database design. I strongly suggest that you read some tutorials on relational databases, such as:kanchan wrote:is there any method to join 2 mysql tables..
i m thinking to make a gallery page and i think for the gallery i need to tables and it may need to join both tables....
is there any way to make simple gallery script with mysql backend?
Help me guys..... i am a simple php coder(not a professional)....
http://www.campus.ncl.ac.uk/databases/d ... esign.html
http://www.kirupa.com/developer/php/rel ... design.htm
http://www.tekstenuitleg.net/en/article ... tutorial/3