In mysql is there a way to save a query?

What do you mean by "save"? Insert, save to file, export, ...?

Save, as in you could run the query daily.

If the query is 'Q', simply run a program every day (see 'cron') that includes:

mysql_query('Q');

(The answer to your original question is strictly "Yes", because you can make a table with a column 'query' and save queries in it. But it's not clear what use this would actually be.)

I'm sorry, I'm relatively new to databases. I didn't know you could save queries in a table.

Well, you can save strings in a database table, and queries are strings, therefore (provided you escape them properly) you can save queries in DB tables.

Or did you mean parameterized statements?

What difference would it make? Are not parameterized statements represented by strings? (There's the obvious problem of how to pass the parameters, but the question is so up in the air my head is spinning.)

I'm just guessing at what the OP might have meant by "save a query"...

Then you should take a look at http://devzone.zend.com/6/php-101--php-for...olute-beginner/ , where there's also a chapter on databases (part 8).

Thank you so much for the advice