two mysql issues :)

Hi All, I am in sql mode today. Two issues that bother me: 1- I had a script" select user_id, username from users having user_id = max(user_id) my max user_id = 150 or something, but script kept bringing 122 I fixed the issue by using a select max(user_id) and select username from users where user_id = $v_user_id 2- select max(commission) where territory=1 and salesperson=2232; this query should return 0 zero b/c it's a sum..... but it returns null. any comments how I can work around this!!! thanks. Mehmet Erisen http://www.erisen.com --------------------------------- Do You Yahoo!? Send FREE video emails in Yahoo! Mail.