No result returned (odbc_query)

[werks]

Please help me on this.. When i search for a specified string in my OPAC (Online Public Access Catalog) it doesn't return any result.. Im using PHP and MS Access. My query is like this

$query = odbc_exec($odbc, "SELECT * FROM qryOPAC WHERE Title LIKE '%$exp%';") or die (odbc_errormsg());

--
Kenneth
"Better Than Yesterday"

[dlite922]

....or die (odbc_errormsg());

...so what's the error message?

[ronverdonk]

odbc_exec in itself does not return query results except for the RESOURCE ID.
After the exec you must read the result set by using some command like 'odbc_fetch_*', e.g.
[php]while ($row = odbc_fetch_row( $query)) {
// handle the result row
}[/php]
Ronald