mysql problem

haziwkd

i want to execute select and update in one query
how can i do?

i wrote:
$sql="UPDATE `viewcount` SET `count` = `count` +1 LIMIT 1 ;
SELECT * FROM `viewcount`";
mysql_query($sql,$link);

then............
You have an error in your SQL syntax near '; SELECT * FROM `viewcount`' at line 1

mathiaus

Dont know if you can do it all in one query. Even if you can it'll most likrly be tricky or something.
Whats wrong with multiple queries?

haziwkd

i want to make a counter
if i want to update the number number of visit before show the number of visit
then i wrote:
$sql="UPDATE `viewcount` SET `count` = `count` +1 LIMIT 1" ;
mysql_query($sql,$link);
$sql="SELECT * FROM `viewcount`";
mysql_query($sql,$link);

i just want to how can i do that in another way

kv

ml

abhinav_shah

You can't execute multiple queries in MySql.

haziwkd

ok
thanks all~