Posted by Tom on 12/04/06 17:47

On Mon, 4 Dec 2006 11:40:38 +0100, Gaga wrote...
>
>If i pull data from one table and if i need just one field ( lets say user
>ID ) from other table, what should i do to make this work. I want to read
>all data from one table and then make the comparation of the passed data and
>the user ID data, in other table....( user id is in users table and all
>other data is in data table ).
>

If I understand you correctly you have two tables "users" and "data". If you
have the userid as the primary key in the users, you can use that id as a
secondary key in your data table. That way you can build a relationship between
the two tables and can group the information correctly in your SQL.

Tom
--
Help a Community by Participating in Ours
We donate your subscription fees to the charity you choose
100% of your first month, 10% thereafter.
http://newsguy.com/charity.asp

• Next in forum: $POST is the differnce char or a reserved name
• Prev in forum: Re: saving and displaying picture in mysql
• Thread view: Re: using fields from two tables - mysql

[Reply to this message]