Hi,
I am new to PHP but I have been using it for the past month. I have set it up on my machine no problem using Apache and MS Access but now when I try to move the code and Access database to a server running IIS I am not able to retreive any information from the database. PHP works fine on the new server because I can get to the admin, but when I try to execute a simple query I get no results. The datasource has been set up in the ODBC's in administration. Does anyone have any ideas that I may try to see if it works. Also i included the code below for the query. Search_string is coming from prior form page.
$search_string=trim($search_string);
if ($search_string) {
// CONNECT TO DB
$odbc = odbc_connect ("test_DB", "root", "") or die( "Could Not Connect to ODBC Database!");
$sql="SELECT * FROM capability_list WHERE engine_pn LIKE '%$search_string%' OR other_pn LIKE '%$search_string%'OR cas_oem_pn LIKE '%$search_string%'" ;
$query = odbc_exec($odbc,$sql) or die (odbc_errormsg());
//CALLING THE RECORD COUNT
echo better_odbc_num_rows($odbc,$sql) . " records matched your query for " . "<strong>" . "\"$search_string\"" . "</strong>";
//CHECK TO SEE IF THERE WAS ANY RESULTS
if(better_odbc_num_rows($odbc,$sql) == 0) {
echo "<p>No matches were found.";
} else {
// OUTPUT
echo "<p><table style=\"border:1px solid " . $background2 . "\" border=1 cellspacing=1 cellpadding=5>\n";
echo "<tr><th>CAS/OEM #</th><th>TEAM</th><th>CELL</th><th>ENGINE</th><th>OTHER</th><th>CAPABLE</th><th>DESCRIPTION</th><th>DETAIL</th></tr>\n";
$x=1;
etc......
