Dynamic Columns

[nashirak]

I am trying to create a query wearby I can select a certain column based on which table it is. My query looks like

select * from Items, Movies, Music where Music.id = Items.id or Movies.id = Items.id;

Now what I want is to select the Artist Column if the result is from the Music table or the Title Column if its a from the Movie table. I would preffer to do this in one query. Is this possible? if so how? Thx.

[jnuneznyc]

The best way would be via php SQL Query building...

if( $table == 'Movies' ){
    $sql = 'SELECT Title FROM Items, Movies WHERE Movies.id = Items.id';
}else{
     $sql = 'SELECT Artist FROM Items, Music WHERE Music.id = Items.id';
}

or you can use SQL Conditional Statements

$sql = 'SELECT ( IF( Music.Artist = NULL, Movies.Title , Music.Artist ) ) AS theItem, Music.Artist, Movies.Title from Items, Movies, Music where Music.id = Items.id or Movies.id = Items.id';