update script not working

[Anon]

i made the folowing script for updating the cell "clicks" in the table "termine2002" - it doesn`t work - please HELP !

$abfrage = "SELECT * from termine2002 where Eventname like '$Ev'";
$erg = mysql_db_query($dbname,$abfrage,$dbverbindung);
for ($i=0 ; $i<mysql_num_rows($erg); $i++)

{
list($Jahr,$Monat,$Tag,$Eventname,$Plz,$Ort,$Land,$Ansprech,$Telefon,$Email,$Internet,$Anmeldesys,$Eventsv,$Live,$Bemerkung,$onlinenummer,$user,$pass,$Videoonline,$mpegvideoname,$mpeggroesse,$divxvideoname,$divxgroesse,$Bilderverzeichnis,$Selbsteintrag,$Ueberprueft,$Anmeldesysende,$clicks) = mysql_fetch_row($erg);
$clickcount=$clicks + 1;
echo"$Eventname $clicks $clickcount";

UPDATE termine2002 SET clicks=$clickcount WHERE Eventname='$Ev';
}

[tubedogg]

Well, for starters, mysql_db_query is deprecated and should not be used.

Instead of
mysql_db_query($dbname,$abfrage,$dbverbindung);
use this:
mysql_select_db($dbname,$dbverbindung);
mysql_query($abfrage);

You can leave off the $dbverbindung unless you have multiple connections open at the same time.

Secondly, your UPDATE query is simply written in the PHP script, it is not ever sent to MySQL. You need to enclose it in mysql_query() to have MySQL update.

mysql_query("UPDATE termine2002 SET clicks=$clickcount WHERE Eventname='$Ev'");

[Anon]

thank`s for your answer ! i will try it.