php - Twice a where in a survey -

instead of wanting whole table want 1 result based on link.

this works:

$bandid = intval($_get['bandid']); $sql = "select              bandid,              naamband,              contactband,              genre,              omschrijving,              leden,              plaats,              prijs,              boekerid,              website,              youtube,              notities                        `bands`                       bandid = $bandid"; 

$bandid clicking link on previous page, wanted combined above

$sql = "select              naam,             bandid,              naamband,              contactband,              boekerid                      `bands`          inner join              `adres`                       `bands`.boekerid = `adres`.id "; 

but doenst work:

$bandid = intval($_get['bandid']); $sql1 = "select              naam,             bandid,              naamband,              contactband,              boekerid                       `bands`          inner join              `adres`                       `bands`.boekerid = `adres`.id                       bandid = $bandid"; 

please me further, thks

where `bands`.boekerid = `adres`.id bandid=$bandid"; 

replace second and

where `bands`.boekerid = `adres`.id , bandid=$bandid";