Created a table which will be used to track/process URLs:
CREATE TABLE dbURLlist(
ID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
AGING TINYINT UNSIGNED ***** ,
URL TINYTEXT NOT NULL,
PRIMARY KEY (ID),
INDEX (URL (25)))
In a PHP script (also prototyped using MySQL-Front) I tried:
UPDATE dbURLlist SET AGING=AGING+1
When ***** was set to DEFAULT 1 every record updated to 2, as expected; whereas when
***** was set
to NULL or DEFAULT 0, it refused to update any of the records present.
The UPDATE command is stripped back to its bare essentials, but it still doesn't work
(from 0) as I
expected. What is the obvious assumption that I've missed?
Please advise,
=dn
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
