Amending data in a row

Dark_Munk

Hi,

I have a table and basically I want to decrease a number in row 0 in a column called pageviews. I was just wondering on how to do this without completely rentering the data for that row...

Thanks in advance.

jdorsch

Dark.Munk wrote:
Hi,

I have a table and basically I want to decrease a number in row 0 in a column called pageviews. I was just wondering on how to do this without completely rentering the data for that row...

Thanks in advance.

UPDATE table SET pageviews = pageviews - 1 WHERE rowID = 0

Dark_Munk

That still didn't seem to work... I put it in this expression:

$query = "UPDATE adscript_ads SET pageviews = pageviews - 1 WHERE rowID = $adnum";

mysql_query($query);

$adnum is the correct id (0) because I have also put it into a link. I've checked my database and the row and the pageview has still stood at 500 for some reason?

jdorsch

Dark.Munk wrote:
That still didn't seem to work... I put it in this expression:
$query = "UPDATE adscript_ads SET pageviews = pageviews - 1 WHERE rowID = $adnum";

mysql_query($query);
$adnum is the correct id (0) because I have also put it into a link. I've checked my database and the row and the pageview has still stood at 500 for some reason?

Well rowID should be replaced with the primary key field name of your table. So if your primary key is adscripts_ads_id then use that. If you don't have a primary key field then make one.

Dark_Munk

Thanks a lot, works a charm.

🙂