PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Using the following code to show transactions taken place by a student along with the balance of their account. But i'm getting a "Unknown table 'students' in field list" error.??
$sql="SELECT transaction.*, students.studentid FROM transaction
JOIN users
ON transaction.studentid=students.studentid
WHERE students.studentid="$username"";
$sql="SELECT transaction.*, students.studentid FROM transaction
JOIN students
ON transaction.studentid=students.studentid
WHERE students.studentid="$username"";