Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
I have a problem to fetch values from a view. The view is simple joint of 3 tables. Something likeCode: Select all
CREATE VIEW AList AS
SELECT a.Name, b.Index, c.Value
FROM TblA a, TblB b, TblC c
WHERE a.No = b.ANo AND b.No=c.BNoMy code is very simple. It goes like this:
Code: Select all
$query = 'SELECT * FROM Alist WHERE Index=10';
$conn = new mysqli('localhost', 'User', 'password', 'database'); // this is OK
$result = $conn->query($query); // this failsMy query executed from MySQL works fine.
I was wondering someone knows a workaround or maybe I am missing something here.?
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]