Adding

[korrupt_23]

Hey, I was just wondering the easiet way to add to a column. I\'m attempting to use:

 

<?

include("connect.php");



$sql4 = "UPDATE `user_info` SET `user_movie_points` = `user_movie_points+1` WHERE `user_id` = \'$userid\' LIMIT 1;";



 	mysql_query($sql4);

?>

 

But it doesn\'t seem to work.

 

Anyone see anything worng, or can give me a better way?

[Barand]

Nearly there! Just move the backtick (although you only need them if your field name is a reserved word or contains spaces)

 

[php:1:6aa6cb6f8e]<?php

$sql4 = \"UPDATE `user_info` SET `user_movie_points` = `user_movie_points` + 1 WHERE `user_id` = \'$userid\' LIMIT 1\";

?>[/php:1:6aa6cb6f8e]

[korrupt_23]

Thanks so much man! That stupid litte backtick :x

 

I love this place, everyone always trys to help, or helps wonderfully! Weee!