I have a code to create VIEW in mysql database which is working fine on my local server. It creates and crop view normally. But on my Online server it gives error
"CREATE VIEW command denied to user"
for online database I manually create VIEW in Database form PHPmyAdmin [Myadmin is in localhost online] it creating, SO i have permission to create VIEW on online database.
But with php mysql_query
it is giving command denied
error. is there any service to be on for creating view with php.