Dear Jamie,
in PHP, the mysql_query(SELECT ... LEFT JOIN ...) will return exactly
what you need. Try something like
WHILE ($i < mysql_num_rows) {
for ($j = 0; $j < mysql_num_fields; $j++) {
$i[$j];
}
$i++;
}
Regards,
Stefan Hinz (Geschäftsleitung)
iConnect e-commerce solutions GmbH
www.iConnect.de - www.js-webShop.de
TEL +49 30 46307-382 - FAX -388
---
----- Original Message -----
From: Jamie Burns <[EMAIL PROTECTED]>
To: Dennis Salguero <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 11:48 PM
Subject: Re: quickie!
> 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
>
>
---------------------------------------------------------------------
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
