|
|
Posted by Erwin Moller on 04/27/06 10:53
Ian Davies wrote:
> Hello
>
> I have seen some tutorials to put a update a counter field in a record. I
> have the counter field in a table that also has a field for a path to
> file.
>
> I display the records in a table on a web page e.g.
>
> IndexNo ............Title................................ Link
> ................................... Count
>
......1.............MyFileName........www.mysite/files/MyFileName.doc........
> .....0
> etc
>
> User can click on the Link field in the table to download the file.
>
> The problem is I can't find a way that will run an update query along the
> lines of
>
> $Query = mysql_query("UPDATE Resources SET Count = Count + 1 WHERE
> IndexNo
> = '$IndexNo');
>
> when the user clicks the link
>
> Can anyone suggest a way or direct me to a tutorial
>
> Thanks
> Ian
Hi,
Your question is very clear, but if I understand right, this may help:
1) Make a link to a increasecounter.php and add the filename:
<a href="increasecounter.php?filename=MyFileName.doc">
2) In increasecounter.php:
$filename = $_GET["filename"];
// do your update in the db here
3) Redirect to the file
header("Location: MyFileName.doc");
exit;
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|