[SOLVED] MySQL AS

[The Little Guy]

how do you AS, in mysql?

 

The below doesn't work, I want to rename the returned column to "linkto" how do I do it since this doesn't work

SELECT * FROM friends_image_comments,users,friends_images WHERE 
friends_image_comments.posterID = users.id as `linkto`
AND
users.id = friends_images.ownerID
AND
friends_images.`default` = '1'
AND
friends_image_comments.ownerID = '{$_SESSION['id']}'
AND
friends_image_comments.view = '0'

[Wildbug]

"AS" has no place in the WHERE clause.  You can alias tables or columns, but you need to do that in either the SELECT or FROM clauses.  What are you trying to do?