On Fri, 17 Sep 2010, Roger Andersson wrote: > To: 'General Discussion of SQLite Database' <[email protected]> > From: Roger Andersson <[email protected]> > Subject: Re: [sqlite] UNIQUE PRIMARY KEY on TEXT column? > >> I'm getting there now ;) >> >> Keith > > I don't know if this will be of any help but you can do something like > UPDATE file_downloads set > dl_count = dl_count + 1 > where filename = "$dl_file";
Hi Roger. Yes, that's viable. I've been writing a PHP script and did the increment in that. Either way it's gonna work. I know you are supposed to put as much of the logic into pure SQL code, but as it's only a simple SQL command, so it probably doesn't matter in this scenario. Keith ----------------------------------------------------------------- Websites: http://www.karsites.net http://www.php-debuggers.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] ----------------------------------------------------------------- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
