Trying to optimize this MySQL query (select, insert and update in the same query)

i have this query from php:

mysql_query("INSERT INTO ".table_hack." (id,ip,count,lasttime) 
             VALUES (NULL,'".$ip."',1,NOW()) 
             ON DUPLICATE KEY U开发者_运维技巧PDATE count=count+1, lasttime=NOW();");

As you can see im inserting a new record on the table_hack only if the Unique element is not present that in my case is ip. If the element is present the query updates de value of count in 1 and lasttime with the NOW() parameter.

I want also to know the value of count in the same query, it is possible?. I know that i could make another query but i will like to make it just in one (if is possible). Thanks for any help!

Nope, you can't.
Also, I see no reason for such a desire.

To me, it's interesting phenomenon. Such questions are quite often on Stackoverflow and I am curious why people so eager to combine queries into one call. And even more surprising fact that everyone are limiting themselves with just 2 queries, and nobody asks how to combine ALL the queries from the script into one mysql call.

You can't combine an INSERT and SELECT query so you'll have to run two queries. Why would it be a problem to use two queries?

You can not do it with standard php mysql functions. You can do it with Mysqli driver and method multi_query(), but it will be a 2 queries whatever.