mysql_query not returning values for complex sql statement [closed]

mysql_query not returning values for complex sql statement [closed]

References

Reference NO 1

http://www.w3schools.com/php/func_mysql_query.asp

Reference NO 2

http://stackoverflow.com/questions/14744528/mysql-query-returning-resource-id-8-instead-of-desired-value

Reference NO 3

http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/data-retrieval-and-manipulation.html

Reference NO 4

http://php.net/manual/en/function.mysql-insert-id.php

Reference NO 5

http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/

Reference NO 6

http://codular.com/php-mysqli

Reference NO 7

http://www.tuxradar.com/practicalphp/9/4/3

Reference NO 8

http://www.mytoptutorials.com/php/php-mysql-select/