PHP & MySQL - Inserting??

[Cheeko]

Hi,

Can someone give me a small example how to edit a row with an id number of say 8 and add one to a field called views?

$res = mysql_db_query ("dammitu_music","insert into 'm_rev' ('views') Values('".$row["views"] + 1."') where id='$id'");

This causes a parse error

Why?

[scoutt]

try this

 $sql = "select * from $table where id = '$id' ";
       $result_check = mysql_query ($sql);
         while ($row = mysql_fetch_array($result_check))
        {
         $views= $row["views"];
         
        }
$views = $views + 1;
$sql_update = update $table set views = $views where id='$id'");

$result = mysql_query ($sql_update); 

something like that should work beter for ya.

[Matthew Draper]

$sql = "UPDATE $table SET views = views + 1 WHERE id = '$id'";
mysql_query ($sql);
if (mysql_errno () > 0) {
   $sql = "INSERT INTO $table (id, views) VALUES ('$id', 1)";
   mysql_query ($sql);
} 

That should work, and only one query.

EDIT: Only one query, unless the counter isn't already in the DB.