WampServer

What I've tried to enter is two fields with one of the data matching a post that's already in. Eg: What's already in: Nilsson, Gert What I try to enter: Nilsson, Nils What's already in: Pipkorn, Bengt What I try to enter: Bentsson, Bengt Please don't tell me that all the surnames, first names and sources has to be unique in order to get a new post.
Forum: WampServer English

Thank you! I'll give it a try, though I found a loophole (empty database, turn on auo_increment, import the files with set key values and then import the files without key values set) I'd still like to know though why it doesn't work with inserting data from a script. I keep getting: Error: Duplicate entry '0' for key 1 every time I try, even when leaving the key fields blank. ETA: I've se
Forum: WampServer English

BTW, wouldn't default mean that auto_increment would start from 1, which doesn't work if there's already data with manually given keys in the table, if I've understood everything correctly. Please explain this a bit more to me.
Forum: WampServer English

Like this? which doesn't work... ALTER TABLE author AUTO_INCREMENT=default Tried to change under settings (operations) but it doesn't work there neither........
Forum: WampServer English

I've got my other question partly sorted so now I wonder why I can't set auto_increment to start at a certain number. I've tried ALTER TABLE author AUTO_INCREMENT=100586 in the SQL box but it doesn't seem to work as I keep getting the same error as I got in my other post when I try to insert data through a form. Please help ASAP.
Forum: WampServer English

I do not use a password for my database, which works fine with SELECT-queries, but not with INSERT-queries as I get this error when I try to insert data through a script. I use the latest version of Wamp and need a solution to this ASAP (preferably yesterday ) Warning: mysql_connect() : Access denied for user 'root'@'localhost' (using password: YES) in C:\wamp\www\directory\insert_db.php on li
Forum: WampServer English

I suppose that means that I have to set the keys to unique numbers then? Am currently working with a php form, but have some trouble with the connection to the database. The form works perfect when run on another server but not when I try to run it locally. It just doesn't collect any data from the database., everything else is fine.
Forum: WampServer English

I use WAMP 5 and have a trouble with subqueries on more than one table. I can't combine two tables if I set my primary keys to unique numbers, but I can combine two tables but not a third one if I don't set the primary keys to unique numbers. What's wrong here? Can someone help me out quickly on this one please?
Forum: WampServer English