MySQL Forums
Forum List  »  PHP

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);

Options: ReplyQuote

Written By
March 14, 2018 12:22PM
March 14, 2018 03:39PM
March 15, 2018 05:40PM
March 15, 2018 07:33PM
Re: SQL error on php page
March 16, 2018 07:14PM
March 16, 2018 07:19PM
March 17, 2018 09:08AM
March 17, 2018 10:41AM
March 18, 2018 12:10PM
March 18, 2018 06:20PM
May 09, 2018 03:33AM

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.