Jump to content

Archived

This topic is now archived and is closed to further replies.

korrupt_23

Adding

Recommended Posts

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? :(

Share this post


Link to post
Share on other sites

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]

Share this post


Link to post
Share on other sites

Thanks so much man! That stupid litte backtick :x

 

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.