To answer your question, we need to pretend to be your MySQL server for a
second. You appear to be posing the following question to your server
SELECT playlist.name as playlist_name
, artist.name as artist
, artist.'.$language.' as bio
, artist.purchaseLink
,
I am trying to make a proper subqueryjust not sure bout the syntax
I use this this basic query to connect all of my tables:
# here is the basic query that connects all the tables..this works :)
$sql = 'SELECT playlist.name as playlist_name, artist.name as artist,'
. ' artist.'.$language.' as