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
