Martin Zvarík wrote:
This will work:

$sql = "
SELECT admin.AdminID, workorders.WHAT_YOU_WANT
FROM admin
INNER JOIN workorders ON admin.AdminID=workorders.AdminID
HAVING admin.username='".$_SESSION['user']."'

Don't use having in this case - this should be a 'where' clause.

A 'having' clause is processed AFTER everything else (after where, after joins, after aggregate's are calculated like sum/max/min), using it like this will cause performance issues where you shouldn't have any.

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to