I am trying to execute a query using mysql_query function but it does not return anything. I dont want to use any function provided by moodle to execute the query. Can any one tell me how can I execute the query using mysql_query function
Try the Databases forum.
As Itamar has pointed out this is not a Moodle Database activity question, but a question relating to mysql (underlying database for Moodle), so the link he has provided is to the correct Forum
You can quickly install phpmyadmin and write SQL queries - but if you are at the level of actually writing SQL queries you probably know that already
To use mysql_query, u need connect mysql and select a database, then only u can run mysql_query function successfully...pls check mysql_query function using details