The problem is this SQL sentence:
It works fine when executed directly in Access but through the ODBC I just recieve an empty recordset. If I remove the [*] before and after the search criteria and type the exact title I get the results. Can't I use * via ODBC?$sql = "SELECT DISTINCTROW * FROM news WHERE ((news.title) Like '*" . $search . "*') ORDER BY news.title, news.author;";
Can anyone help me with this?