update tablename set trackdate = trackdate + 1

Could it be that now() returns date time and your field is only date?

Not sure I'll be much help. Only thing I'll mention is careful with using IN since it can be expensive. I can't think of other ways based on your requirements than what you have already mentioned....

I apologize, I misunderstood what you were doing. Full-Text searching would work I believe. For example:

select *
from sentence
where match(`text`) against ('+today +good' IN BOOLEAN MODE);
...

select *
from sentence
where sentence_id in
(
select distinct sentence_id
from word
where `text` in ('today','is')
)

You could also use distinct instead of group by, I don't remember...

Here is one way:

select *
from sentence
where sentence_id in
(
select sentence_id
from word
where `text` in ('today','is')
group by sentence_id

So you want to search for one or many words to see all the different sentences they exist in?

If you want to follow REST or RESTful urls such as the REST architecture states (which seems to be getting more popular) then GET and POST have two very different uses. GET should be used to 'get'...

For simple data, flash can do GET and POST to PHP and then PHP can insert or select from the database. Depending on what version of Flash and Actionscript you are working with, you'll be using...

What you are trying to do is use dynamic referencing. For example, try this:

var name = 'b21'; // this value come from php
this[name].gotoAndStop(3);

This code will use the value of...

Make sure you aren't trying to run MySQL on a port that is already in use.

Can you post your AS code to see what you are trying to do that isn't working? You call php, get a variable which is a name, then you try to load that movieclip correct?

To send complex data types (arrays, objects, recordsets) from Flash to PHP you'll need to use something like AMFPHP (Action Message Format). AMF will convert that complex data type into a portable...

Here's a tutorial showing how to use mysql stored procedures with php. Hope it helps answer you question:

http://www.joeyrivera.com/2009/using-mysql-stored-procedures-with-php-mysqlmysqlipdo/

Here is a tutorial explaining how to create web services in php using amf, xmlrpc, json, and rest. It's using the zend framework but it may still help people understand these a little better (or go...

Here's a quick tutorial on executing mysql stored procedures in php using mysql, mysqli, and pdo for the people using the different database extension:
...