SELECT Query works in phpMyAdmin but not in PHP program 1

[rogerte]

Hi,

If I enter the following SELECT statement in phpMyAdmin it works ok

SELECT A.class_id, A.attend, A.mem_id, B.firstname, B.lastname FROM attendance AS A INNER JOIN memberdetails AS B ON B.mem_id = A.mem_id WHERE A.class_id=5 ORDER BY B.lastname, B.firstname ASC

but if I try the following in PHP it returns the following error: Fatal error: Call to a member function fetch_array() on boolean in C:\wamp64\

http://www\AGC\classregister.php

on line 37 (the line beginning $a_fetch)

$a_query = $conn->query('SELECT  A.class_id, A.attend, A.mem_id, B.firstname, B.lastname FROM attendance AS A INNER JOIN memberdetails AS B ON B.mem_id = A.mem_id WHERE A.class_id=5 ORDER BY B.lastname. B.firstname ASC') or die(mysqli_error($conn));

$a_fetch = $a_query->fetch_array();

$conn is returned from an initial call to a mysqli connect string, and works fine in other db calls throughout the program.

I have tried enclosing column/table names in backticks, but makes no difference.

Can anyone tell me where I am going wrong?

Thanks

 

[vacunita]

It would appear your query is returning a false statement as such $a_query is boolean and not a result object that has a function named fetch_array to call, but is not triggering the die() statement.

What happens if you echo out the error after the query call?

$a_query = $conn->query('SELECT  A.class_id, A.attend, A.mem_id, B.firstname, B.lastname FROM attendance AS A INNER JOIN memberdetails AS B ON B.mem_id = A.mem_id WHERE A.class_id=5 ORDER BY B.lastname. B.firstname ASC') or die(mysqli_error($conn));

[b]echo "The error is:" . $conn->error;
die();[/b]

----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech

 

[rogerte]

Thanks for response.

The echo came back as unknown field A.class_id in field roster

So I changed all the occurrences of A. to attendance. and all the B. to memberdetails (obviously removing the AS A and AS B) and it now runs ok.

Puzzling to understand why that should happen.

 

[vacunita]

It shouldn't happen. Some issue with the table aliases I would assume.

Anyway, glad you got it sorted.



----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech

 

[spamjim]

The queries between phpMyAdmin and the PHP script were not identical.

ORDER BY B.lastname. B.firstname

Your comma lost its tail in the latter query.

You probably caught the error when you changed occurrences of A & B.