Re: select from two tables

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I did not look at the code very much but if you want to select from 2 tables your sql statement is like this: select a.col1,b.col1 from table1 a,table2 b where a.column=b.column && column='value'; I think that if this is what you are looking for this should help... Caleb On Saturday 27 July 2002 6:17 am, Barry Rumsey wrote: > Ok I tired this but it did not help, but thank you. > > -----Original Message----- > From: Herman Verkade [mailto:Herman.Verkade@iqware.co.uk] > Sent: Sunday, 28 July 2002 1:18 a.m. > To: 'Barry Rumsey' > Cc: php-db@lists.php.net > Subject: RE: [PHP-DB] select from two tables > > Well, I'm just a beginner myself, but I would say that: > > echo"<i> by "; echo ($albumby[xoops_artist.artist]); > > echo"<i><br>"; > > should at least be: > > echo"<i> by "; echo ($album[xoops_artist.artist]); > > echo"<i><br>"; > > or even: > > echo"<i> by "; echo ($album[artist]); echo"<i><br>"; > > Hope this helps, > > Herman - -- Get my GnuPG public key http://www.cwalk.org/pgp_info.html See complete mail headers for more information -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9TGBF6k6xsUuSNSsRAnQmAJ9TT6pB7n8WaqVCHixPobIcTYLEXACfcKFz ce+/GnVVNQvQTansb5feuPg= =Jhay -----END PGP SIGNATURE-----