Hey
I building a search function in php using access database, my problem is that when a field in the database contains nothing the search fails, here is the search code....
$result = odbc_exec ($conn,"SELECT ADR01KgkNr,ADR01SokNamn,ADR01Namn,ADR01Adress1,ADR01PersonNrDel1,ADR01PersonNrDel2
FROM ADRR0001 WHERE ADR01SokNamn LIKE '%$fnamn1%'
AND ADR01Namn LIKE '%$enamn1%' AND ADR01Adress1 LIKE '%$adress1%'");
....and the code for presentation
echo ' <option value="'.$myrow["ADR01KgkNr"].'">'.$myrow["ADR01Namn"]." ".$myrow["ADR01Adress1"]. " - ".$myrow["ADR01PersonNrDel1"]. " - ".$myrow["ADR01PersonNrDel2"]. " </option>\n";
how can i get around this, allowing empty fields in the database
/Axel
