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!
SELECT * FROM LFeProp JOIN LettingsTenApp ON LFeProp.propID = LettingsTenApp.propID WHERE tenEmail = %s
Define "works". Are you getting too many rows? Not getting anything at all? Are the LFeProp rows optional or will there be at least one row for everything in LettingsTenApp?
Define "works". Are you getting too many rows? Not getting anything at all? Are the LFeProp rows optional or will there be at least one row for everything in LettingsTenApp?
"SELECT * FROM LettingsTenApp, LFeProp WHERE tenEmail = %s AND LettingsTenApp.propID = LFeProp.propID"
is applied when the user logs in neither the user details are displayed nor the property information. It should be showing the username and the property information
Then there is no matching row in LFeProp. Check your data.
Or there is more than one matching row and thus you'll get more than one row in the results, and your code somewhere requires there be exactly one row.