On Sat, 17 Mar 2001 22:04:37 +0100, "Denis Mettler" <[EMAIL PROTECTED]>
wrote:
Denis,
Can't you tie the table 1 id and the table 2 category_id together?? Or are this
going to be different?? If they are going to be different, I would suggest then
create a "linking" table to link table 1 to table 2.
Cheers,
>>table 1:
>>id, primary key, auto increment
>>name varchar(50)
>>city varchar(50)
>>phone varchar(25)
>>
>>
>>table 2:
>>categorie_id, primary key, auto_increment
>>kategorie varchar(50)
>>
>>
>>in table one i have the contacts
>>and in table two the categories (Business, privat...)
>>
>>but how can i link these tables for a query.
>>i ask because i know that mysql doesn't support foreign keys.
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php