I'm using ODBC to query an MS Access database with the query:
$qry = "select Index,ItemName,etc from Inventory where Type='$type' and Category='$criteria'";
the query is receiving the variables properly, because echoing the qry string returns:
select Index,ItemName,etc from Inventory where Type='2' and Category='1'
but the query is returning 0 entries.... I checked the database and format and so on, and things are fine at the database end, so what's happening here? There should be several entries displayed for each set of values, but it just returns 0 entries...
Can anyone help?
Cheers.
$qry = "select Index,ItemName,etc from Inventory where Type='$type' and Category='$criteria'";
the query is receiving the variables properly, because echoing the qry string returns:
select Index,ItemName,etc from Inventory where Type='2' and Category='1'
but the query is returning 0 entries.... I checked the database and format and so on, and things are fine at the database end, so what's happening here? There should be several entries displayed for each set of values, but it just returns 0 entries...
Can anyone help?
Cheers.