What's wrong now?!! - I can't be that stupid!!...
here's my UPDATE statement:
$res = mysql_query("UPDATE mpdl SET hits=LAST_INSERT_ID(hits+1),since=since WHERE type='dl' AND url='/test.php';");
All the time I'm getting $res=1 even if there is no row affected. If I enter the same query in the mysql command-line I get the following result:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
In PHP, it returns 1. What's wrong?!!!
thanx
Philippo
here's my UPDATE statement:
$res = mysql_query("UPDATE mpdl SET hits=LAST_INSERT_ID(hits+1),since=since WHERE type='dl' AND url='/test.php';");
All the time I'm getting $res=1 even if there is no row affected. If I enter the same query in the mysql command-line I get the following result:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
In PHP, it returns 1. What's wrong?!!!
thanx
Philippo