The Little Guy Posted July 2, 2007 Share Posted July 2, 2007 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' Quote Link to comment Share on other sites More sharing options...
Wildbug Posted July 2, 2007 Share Posted July 2, 2007 "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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.