Hi all, new to the list :)
I would try something like this:
Select name, company, choice
>From Table1, Table2
Where Table1.id = Table2.id;
Fg
> Can someone please help me or direct me to some scripts that might get
> me unstuck, as I've not done this kind of query before.
>
> To simplify:
>
> Table1
> id 1
> Name John Doe
> company IBM
>
> Table 2
> id 1
> choice choice #1
> id 1
> choice choice #2
>
> So I have 2 records in table 2 that I need to tie in with id # 1 in
> table 1.
>
> What's the smartest way to do the query ? I have 5 different tables I
> need to query. I guess I can get the data I want by selecting all
> from the 5 tables then parsing through like:
>
> while ($row = mysql_fetch_assoc($res)) {
> foreach Table1.id {
> if Table1.id == Table2.id{
> echo <tr>
> }}}
>
> I could probably manage if I do 5 different queries with 5 different
> results sets, but that is obviously inelegant and would create more
> overhead
>
> I need to display as:
>
> John Doe IBM Choice #1, Choice #2
>
> Am I even close ? Need some help with the logic...
>
> Thx for any guidance
>
> mignon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
