that is the answer, but i think i was looking for something different.
because i am using php, i am used to results being returned in an array, and
was hoping to get this sort of thing out...
$results[0]['id'] // table1.id
$results[0]['name'] // table1.name
$results[0]['subject'][0] // table2.subject
$results[0]['subject'][1] // table2.subject
$results[0]['subject'][2] // table2.subject
i am guessing mysql doesnt have a notion of multidimensional results...
i will sort them myself ;o)
thanks anyway, just me trying to make things too efficient...
jamie.
----- Original Message -----
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 10:32 PM
Subject: Re: quickie!
> Are you looking for:
>
> SELECT table1.name, table2.subject
> FROM table1, table2
> WHERE table1.id=table2.student_id
>
> Good Luck,
>
> Dennis
> **********************************************
> Beridney Computer Services
> http://www.beridney.com
>
> ----- Original Message -----
> From: "Jamie Burns" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, August 05, 2001 2:25 PM
> Subject: quickie!
>
>
> hi..
>
> can someone tell me how i get the data from two tables, where table1 will
> have one row, and table2 will have many rows?
>
> eg:
>
> ================================
>
> table1:
>
> id name
>
> 1 barney
> 2 fred
> 3 wilma
>
> table2:
>
> id student_id subject
>
> 1 1 english
> 1 1 cookery
> 1 1 maths
> 1 1 science
> 1 2 woodwork
> 1 3 cookery
>
> ================================
>
> do i have to use two queries to get all this data out in usable form?
>
> thanks,
>
> jamie.
>
---------------------------------------------------------------------
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
