Problem with SQL Update when using RewriteRule

errorCode30

Hi guys,

I have a problem,

I have some code to update the views on a page.

it works great, when i access the page like this:

www.site.com/page.php?type=1

BUT

when i access the page using my rewriterule:

www.site.com/1/name-of-page.html

the update is called 6 times at a time. so instead of going up, 1,2,3,4 it goes up 6,12,18,24

Can anyone help please.

Cheers

bradgrafelman

I'm just guessing here... no clue if this'll help at all...

Do you have other RewriteRule entries? If so, next to the one that resolves this URL, have you tried adding the L flag?

Also, can you post your .htaccess file (specifically, all that pertrains to mod_rewrite) and perhaps some of the code from the page that updates your DB?

errorCode30

Hi, thanks for your help, my exact htaccess file is:

php_flag session.use_trans_sid off
RewriteEngine On
RewriteRule ^{([-+A-Za-z0-9]+)/?(([0-9]+).html)?$} list.php?cat=$1&page=$3 [L]
RewriteRule ^([-+A-Za-z0-9]+)/?([0-9]+)/(.*)(.html|/)?$ get.php?cat=$1&itemID=$2&name=$3 [L]
AddHandler application/x-httpd-php .php

DB code on page:

$chandle = mysql_connect($dbpath, $dbuser, $dbpass) or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser);

$query1="UPDATE `" . $Table . "` SET `views` =views+1 where `id` = '$fileID' LIMIT 1"; 
mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1);

Thanks for any help.

The page and the update to the "views" works perfect when the page is viewed without RewriteRule, but as soon as i access the page though that, it adds 6 to the db each time.

Cheers.

errorCode30

Any help with this would be really appreciated.

Thanks.

liquorvicar

Have you tried enabling Rewrite logging? That's often helped me in the past when I've had a problem with the Rewrite engine.

errorCode30

I dont know anything about htaccess files mate, i wouldnt even know how to do that.

Could you give me a code example please?

Cheers.

-- Also, how can i allow ' and . in the page names in this: (([-_+A-Za-z0-9]+))

liquorvicar

You can't set Rewrite logging options in .htaccess Apache docs
You'll need to set it in httpd.conf if you have access to it.