I have an existing database/tables and would like to add a counter to a
table that would increment when a document is downloaded from the
database. I am sure it is an easy addition to the php page but struck-out
looking for info not related to auto-increment in the mysql manual. I
tried adding this to the php page:
------------------------------------------------
(more else statements up here)
elseif ($orderby == 'bg'):
$sql = "select * from manuals_list where cat like 'bg' order by
'file_name'";
else:
$sql = "select * from manuals_list where cat like 'ap' order by
'file_name'";
endif;
$result = mysql_query($sql);
while ( $row = mysql_fetch_array($result))
{
printf("<tr>\n<td class=\"link\">\n
<a
href='../docs/$row[url]'>%s</a>\n</td>\n<td>%sKB</td>\n<td>%s</td>\n</tr>\n",
$row["file_name"], $row["size"], $row["rev"]);
}
count=count+1; <--- This is the added bit --->
?>
-----------------------------------------------
The count doesn't increment in the database. The table has a column called
'count'.
Can someone please please point me in the right direction?
Thanks,
Chip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
