Mysql Update

[TheFilmGod]

I'm trying to grab the value count from mysql and add one to it. This is very simple, but I"m still completely lost! here is the code:

 

require("connect.php");

$result = mysql_query("SELECT fav_count FROM favs WHERE page_id = $page");
$result++;
mysql_query("UPDATE favs SET fav_count = $result WHERE page_id = $page");

echo "Thank you for telling us you like this!<br />Please wait...";
echo "<META HTTP-EQUIV=Refresh CONTENT=\"2; URL=link.php\">";

 

Any help is greatly appreciated!

[Yesideez]

Try this:

<?php
  mysql_query("UPDATE favs SET `fav_count`=`fav_count`+1 WHERE `page_id`='".$page."'");
?>