Re: SQL error on php page
Posted by:
Mark Hwang
Date: March 16, 2018 07:14PM
OK I commented out the previous line and replaced it with die(bye) as shown below. It now just prints "bye". I think the problem is still that the rows cannot be passed back to php.
// Create SQL statement to retrieve additions to CUSTOMER_ARTIST_INT table
$SQL = "SELECT * FROM CustomerInterestsView ";
$SQL .= "WHERE CustomerLastName = '$LastName' ";
$SQL .= "AND CustomerFirstName = '$FirstName'";
// Execute SQL statement
$RecordSet = $PDOconnection->query($SQL);
// Test existence of $RecordSet
if (!$RecordSet) { die(bye);
//exit ("SQL Statement Error: " . $SQL);
}
Subject
Written By
Posted
Re: SQL error on php page
March 16, 2018 07:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.