Newbie: Update record in PHP

[Anon]

Hi Everyone,

Im trying to convert one of my sites from ASP to PHP and need a little help updating a record 🙂

In ASP I do this:-

<%
rsDev.Fields.Item("Hits").Value = _
rsDev.Fields.Item("Hits").Value + 1
rsDev.Update
%>

And this updates the numeric value of this record by 1 in the column 'Hits' in my DB.
I think Im getting close with this in PHP but am stuck! Heres what I have so far:-

<?php
$rsDev->Fields("Hits");
$rsDev->Fields("Hits")+1;
$rsDev->Update;
?>

Im sure I'm getting close, but the value is not updating - can anyone tell me what I'm doing wrong?

Many Thanks,
Jut.

[dolce]

Can not really help you out with this one, since I use direct SQL queris to the database without employing PHPLib (all the functions I have written myself)... and an SQL statement will be:

UPDATE tablex SET col = col + 1 WHERE rowid = '$id'

$id I pass to the query 🙂

see this work at

www.ita-studio.com/photo/

[Anon]

Ahh yes of course - why didnt I think of that!

I appreciate the reply no end!

Thanks again,
Jut.