Maq

Well what are the permission on the directory and who's the owner?

If the client inserts the month, then it seems you should already have it. Maybe I'm confused.

Are you trying to extract the month or insert it?

Please do not double post. I see this is your first but so for future reference there is a "report to moderator link", and you can request to have your thread moved.

Something like this: mysql> select id1, max(id2), somecolumn from testing group by id1; +------+----------+------------+ | id1 | max(id2) | somecolumn | +------+----------+------------+ | 1 | 3 | text | | 2 | 6 | text | +------+----------+------------+ 2 rows in set (0.00 sec) Although I'm not sure what you mean by:

Echo out mysql_error() to see what the problem is. You can also echo out your query to see what it actual is.

Don't redefine $test by assigning it to the array_push.

A couple of things: LIKE '%%' matches anything and everything. There's no point to include those clauses. I meant actually echo the string that's produced implementing the DATE_SUB() function (you should see a date). What language are you writing this in? Please post the relevant code. You would probably want to join these tables. We would need to know the desired result(s) and the table structures.

Can you echo out your query string and post the output?

There is a native MySQL function called, DATE_SUB(), that you should be using. Invoices.DateBilled Edit: I believe you should also be using NOW() as opposed to CURDATE().

Hit it harder, it'll eventually work.

Please elaborate. What in his post suggest racism?

It would be "as UNSIGNED". Are you receiving errors? Have you echoed your query to see what's actually going on? Echoed mysql_error()?

Considering that you're trying to add varchars together, you may have to CAST the substring before operation.

Hmm, yeah I guess you're right. But, it's really with/for the SELECT, not the the INSERT.

cbolson, you can't use a WHERE clause with INSERT.

What's your question?

Read: http://www.tizag.com/mysqlTutorial/mysqlcount.php

Maybe you shouldn't watch so much TV.

Echo $sql3 and post the output.

I receive a 404 not found error.

We may need to see some code, but this usually occurs when you have a fatal exception in JS. The functionality will just go right out the window.

No one suggested that, in fact, that's not even a native method. We're trying to help you and you're doing the complete opposite. Until you're willing to cooperate and listen, you're wasting everyones' time.

2?

If you explain exactly what you are trying to do, maybe we can suggest the best approach. Since you ignored our previous suggestions it seems we're guessing until then. Not sure what the point of this is then?