What's wrong with this? (MySQL select statement)

[rupertbj]

				$query = "SELECT DISTINCT albumName FROM fotoPhotos, fotoUsers WHERE fotoPhotos.userid = fotoUsers.id AND fotoUsers.username = ".$username." ORDER BY albumName ASC";

I don't get an error message.
The variable $username is set and exists in the database.

But there is something wrong that I cannot fathom - any help much appreciated!!!

Thanks

Rupert

[cheerio]

 $query = "
SELECT DISTINCT(albumName) 
FROM fotoPhotos, fotoUsers 
WHERE fotoPhotos.userid = fotoUsers.id 
AND 
fotoUsers.username = ".$username." 
ORDER BY albumName ASC";