adding comments in queries?

[Jaynesh]

hi is it possible to add comments in sql queries.

 

my sql query has gotten so complicated to the point that I don't know which part does what.

[cyberRobot]

You could add PHP comments that describe the query:

http://php.net/manual/en/language.basic-syntax.comments.php

[Jaynesh]

Hi. Yes but how can I add this into the query. for e.g

 

$query = "SELECT $select
//from
FROM dbPosts

//left join
LEFT JOIN dbUsers
ON dbPosts.username_id = dbUsers.id

//left
LEFT JOIN dbFriends
ON (dbPosts.username_id = dbFriends.my_id)"

[cyberRobot]

Instead of embeding the comments in the query, you could do something like:

 

$query = "SELECT $select " .
	 "FROM dbPosts " .                                //from
	 "LEFT JOIN dbUsers " .                           //left join
	 "ON dbPosts.username_id = dbUsers.id " . 
	 "LEFT JOIN dbFriends " .                         //left
	 "ON (dbPosts.username_id = dbFriends.my_id)";

[trq]

mysql uses -- to delimit a comment.

 

$query = "SELECT $select
-- from
FROM dbPosts

-- left join
LEFT JOIN dbUsers
ON dbPosts.username_id = dbUsers.id

-- left
LEFT JOIN dbFriends
ON (dbPosts.username_id = dbFriends.my_id)";

[cyberRobot]

Thanks for jumping in! I tend to forget about MySQL options.