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
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to