Okay, here's the situation:
In Microsoft Access, you can create Queries and then run sql statements against them from an PHP page. So, for example, if you fire up Access, load a database and click on the "Queries" section, and design a query. You can then, from PHP, run a "SELECT * from QUERYNAME WHERE BLAH=BLAH" execution. It basically treats the query like another table. (Maybe it's a microsoft thing?)
So I just converted the database to mySQL and using a GUI interface (Mascon) for mySQL, recreated a QUERY and when I run a sql statement from a PHP page, it tells me that "databasename.queryname" doesn't exist or something.
I'm new to mySQL. Does it store Queries in the database and can you run SQL statements against a query like you can with Access?
Mascon was developed by Scibit <!-- w --><a class="postlink" href="http://www.scibit.com">www.scibit.com</a><!-- w --> as a GUI for mySQL. Any help would greatly be appreciated. Thanks!
-S
In Microsoft Access, you can create Queries and then run sql statements against them from an PHP page. So, for example, if you fire up Access, load a database and click on the "Queries" section, and design a query. You can then, from PHP, run a "SELECT * from QUERYNAME WHERE BLAH=BLAH" execution. It basically treats the query like another table. (Maybe it's a microsoft thing?)
So I just converted the database to mySQL and using a GUI interface (Mascon) for mySQL, recreated a QUERY and when I run a sql statement from a PHP page, it tells me that "databasename.queryname" doesn't exist or something.
I'm new to mySQL. Does it store Queries in the database and can you run SQL statements against a query like you can with Access?
Mascon was developed by Scibit <!-- w --><a class="postlink" href="http://www.scibit.com">www.scibit.com</a><!-- w --> as a GUI for mySQL. Any help would greatly be appreciated. Thanks!
-S