Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always learned ONE table... put EVERYTHING in one database table.

I'm making a profile system so there needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two together? I could probably figure this out faster if someone explained and posted sample SQL code that shows how the two are linked together.

Thanks!!

[N]F

haha... well I guess I'll be a good programmer soon but first I need to build my libraries of code!

[N]F

i hope you wont get as lazy as i am..

darn.. i think i misunderstood a line or two of that saying..

------

if something is hard to do..
then it is not worth doing it.. LOL

its great site to help us
MySQL, Multiple Tables

All you have done a grate job for mysql users like us ... Thanks.

Retrieving Data from Multiple Table
MySQL, Multiple Tables

Table1
Id
Full_name

Table2
Id
Contact_address

Table3
Id
Products

Query option as below
I want to search
? full_name <>
? contact_address <>
? products <>

But record in the format of

Id | full_name | contact_address | products


Please help me the good performance tunning codes. (database in mysql and script language is PHP)

Thanks!

-question by Krishna Aryal

i would recommend reading up on the t1 t2 commands for mysql. it is in the mysql manuel files.

Multiple tables in MySQL
MySQL, Multiple Tables

Replying to nightfoxIn the database I worked on in the 1960s things were so much easier - We just created a field name in the global dictionary that could directly accessa field from another table.
-reply by Leon Wooldridge

get data from two tables plz plz help meout
MySQL, Multiple Tables

I need to write a query which get array of data from one table and then search in second table at basis of result..Please help me..I can forward my code its only return me one record and search that one rec in second table ..I wanna get  more then one rec Please Please Please help me out..

$show_months5="select * from job_application where email='$email'";
Echo "select * from job_application where email='$email'";
                         $result5=mysql_query($show_months5);
                        $get_array5=mysql_fetch_array($result5);
                                        $month5=$get_array5['job_id'];
                                      $show_month_inf="select * from job where job_id='$month5'";
                          echo "select * from job where job_id='$month5'";
                                     $result1=mysql_query($show_month_inf);

-question by moon

Joins between many to many relationships
MySQL, Multiple Tables

Hi Guys,

I'm struggling to understand the Join statements - I've seen many Examples of the Joins between one to many - many to one relationships - But none with many to many - where we have one main table - joint table - lookup table.

I would most probably do it this way:

SELECT * FROM shoes AS sh, colours AS col, shoes_colurs AS shc WHERE sh.Id = shc.Shoe AND col.Id = shc.Colour ORDER BY sh.Name ASC

Now - it would obviously work fine, but the question is - is there a better approach - using perhaps JOIN statement?

This is very simple statement - but I have one which is referring To a larger number of the joint tables as one entity can have more many To many relationships - and this kind of approach can generate quite Long statement - this is why I'm wondering if there's a better approach To this one.

Your help would be appreciated.

-reply by Mark