mysql update query not working in php code

[makoy]

hello everyone I would like to ask how to update a database using the php script. Below is the code that I used for updating but for some reasons it does not seem to work. Can you guys help me? Thank you very much my friends.

<?php
$h = 'localhost';
$u = 'root';
$p = 'password';
$db = 'webcontents';
$id = 1;
$hits = 5;
$dbc = mysql_connect($h,$u,$p) or die('could not connect to database');
$dbz = mysql_select_db($db);
$query = 'update webcontents set hits='.$hits.'where webid='.$id;
$result = mysql_query($query);

?>

[rincewind456]

This line : $query = 'update webcontents set hits='.$hits.'where webid='.$id; if you convert it to what MySQL is going to see looks like this : update webcontents set hits=5where webid=1 see the lack of seperation here hits=5where.
Change your query string to :

$query = 'update webcontents set hits= '.$hits.' where webid='.$id;

[eyedol]

Yes it will not work because of the single qoute used. Use this instead.

 $query = "update webcontents set hits= '$hits' where webid='$id' "; 

[rincewind456]

eyedol wrote:

Yes it will not work because of the single qoute used.

Sorry but your wrong the quotes make no difference to this query. I suggest you check out the manual on strings