I use a mysql database.
I have used a script for months.
Last week, I have to change a value in a collum and I use a very easy script
include("db_connect.php");
$query = "UPDATE rotsen SET rots_naam=\"$rots_naam\", massief_id=\"$massief_id\", rots_beschrijving=\"$rots_beschrijving\", afstand_parking=\"$afstand_parking\", hoogte_minimaal=\"$hoogte_minimaal\", hoogte_maximaal=\"$hoogte_maximaal\", windroos=\"$windroos\", route_schatting=\"$route_schatting\", route_types=\"$route_types\", niveau_3=\"$niveau_3\", niveau_4=\"$niveau_4\", niveau_5=\"$niveau_5\", niveau_6=\"$niveau_6\", niveau_7=\"$niveau_7\", niveau_8=\"$niveau_8\", foto=\"$foto\", rotstype=\"$rotstype\", edit_gebruiker=\"$edit_gebruiker\" WHERE rots_id = $rotsn ";
The properties of my table are
CREATE TABLE rotsen (
rots_id int(11) NOT NULL auto_increment,
rots_naam varchar(255) NOT NULL default '',
massief_id int(11) NOT NULL default '0',
rots_beschrijving text NOT NULL,
afstand_parking time NOT NULL default '00:00:00',
hoogte_minimaal int(4) NOT NULL default '0',
hoogte_maximaal int(4) NOT NULL default '0',
windroos set('unknown','n','no','o','zo','z','zw','w','nw') NOT NULL default 'unknown',
route_schatting int(11) NOT NULL default '0',
route_types set('unknown','sport','boulder','artif','trad') NOT NULL default 'unknown',
niveau_3 int(4) NOT NULL default '0',
niveau_4 int(4) NOT NULL default '0',
niveau_5 int(4) NOT NULL default '0',
niveau_6 int(4) NOT NULL default '0',
niveau_7 int(4) NOT NULL default '0',
niveau_8 int(4) NOT NULL default '0',
foto enum('','on') NOT NULL default '',
rotstype varchar(255) NOT NULL default ',',
edit_gebruiker int(11) NOT NULL default '0',
PRIMARY KEY (rots_id)
) TYPE=MyISAM;
The very funny and stupid things is I can only change 1 row.
The other 520 one's are blanc when I would update the value's.
Somebody a solution.
