Hi all!
Here's the problem:
I want to update one record in database. But, i do not know how to do the query... : (
OK, it's easy directly at mysql prompt, but i need it from site to be done as well
Here's the code:
include ("../../../pwa.incl.php");
$connect = mysql_connect($host, $user, $pass)
or die("Kan geen verbinding maken met database");
mysql_select_db($db) or die(mysql_error());
$query = "update pwa set i1 = '".$i1."' where f0 = '".$c0."'");
mysql_query($query) or die(mysql_error());
mysql_close($connect);
I have noticed that in $query many use:
"update pwa set i1 = '$i1'
I guess that that works on linux? On windows, at least for insert statement should be used as it says above. So, i tried the very same with update. But, it doesn;t work. Error that generates is:
Parse error on line xx (donno number, but that the line where query is).
Can anyone help me with this?