script question

[Anon]

Hi all,
How do i add the following code into the script below: active=\'yes\'

$query = \"SELECT bands.band_name, gig.band_id, gig.perform_date FROM bands, gig WHERE bands.band_id = gig.band_id\";

Cheers,
micmac

[van__]

$query = "SELECT bands.band_name, gig.band_id, gig.perform_date FROM bands, gig WHERE bands.band_id = gig.band_id AND gig.active=yes";