Re: Re: php can't insert data mysql table

> > I think the comment about your "cannot insert query" was because it really > did not make sense. Once truly cannot "insert a query". Since you ask > tho, a more approp message might be > "Insert query failed to execute.<br>Error returned was " . mysqli_error() > . "<br>Query was $q" > > As for your index issue - you are using an autoincrement(?) field as the > primary key. Is this related to another record in your db? If not, why > even have the primary key? > > Hey! I really like your error message. Borrowing it! :) Yes I am now using auto_increment, and that's what seemed to solve my issue. Looks like a simple omission in forgetting to use auto_increment and using primary key. I usually know better. I'll blame this one on the clonopin. lol thank you tim On Mon, Oct 1, 2012 at 12:30 PM, Jim Giner <jim.giner@albanyhandball.com>wrote: > On 10/1/2012 12:20 PM, Tim Dunphy wrote: > >> hey thanks guys adding debugging info worked. >> >> Actually it was mysqli_error() providing me with a specific error of where >> the problem was. >> >> Cannot insert query:Duplicate entry '0' for key 'PRIMARY' >> >> This is the data in the table >> >> mysql> select * from guitarwars; >> +----+---------------------+--**-----------------+-------+----** >> ---------------+ >> | id | date | name | score | screenshot >> | >> +----+---------------------+--**-----------------+-------+----** >> ---------------+ >> | 0 | 2012-10-01 11:55:45 | Tommy Tutone | 2442 | >> bg_titlestrip.jpg | >> | 1 | 2012-10-01 08:34:18 | Dunphy | 20000 | proof.jpg >> | >> | 2 | 2012-10-01 00:25:53 | ray davies | NULL | 2241 >> | >> | 3 | 2008-04-22 14:37:34 | Paco Jastorius | NULL | NULL >> | >> | 4 | 2008-04-22 21:27:54 | Nevil Johansson | NULL | NULL >> | >> | 5 | 2008-04-23 09:12:53 | Belita Chevy | NULL | NULL >> | >> | 6 | 2008-04-23 14:09:50 | Kenny Lavitz | NULL | NULL >> | >> | 7 | 2008-04-24 08:13:52 | Phiz Lairston | NULL | NULL >> | >> | 8 | 2008-04-25 07:22:19 | Jean Paul Jones | NULL | NULL >> | >> | 9 | 2008-04-25 11:49:23 | Jacob Scorcherson | NULL | NULL >> | >> +----+---------------------+--**-----------------+-------+----** >> ---------------+ >> >> >> This was the query I was using: >> >> $query = "INSERT INTO guitarwars (date, name, score, screenshot) VALUES >> (NOW(), '$name', '$score', '$screenshot')"; >> >> It seems to be inserting a default value of 0 since the id is not being >> specified and that's when I realized that I had failed to auto_increment >> the id column. D'oh! So once I did that everything worked like a charm. >> >> @Ken >> >>> First -- NEVER post code with your database username/password. Since you >>> >> did, change your db password immediately. >> >> Well actually I did not. Did you really think 'secretsauce' was my >> password? :) But I guess you're right in that this may be a little >> ambiguous when seeking advice in lists so from now on I will take your >> advice on making login information unambiguously fake in the form of >> user='xxxx' and password='xxx'. >> >> @Stuart >> But take note of what everyone else is saying. You should be getting the >> error message when this happens which will tell you exactly what the >> problem is, above and beyond "Cannot insert query" (which, btw, makes no >> sense at all :)). >> >> Ok well I'm using an 'insert' query so I'm not sure why you say that >> this >> makes no sense at all. :)) If you don't mind giving this n00b advice what >> would be a better/more accurate error message? >> >> They take away from this for me was.. don't skimp on the error messages! >> The one I got was so clear that fixing the problem was easy at that point. >> >> But thanks again guys.. this list has been an indispensable source source >> of wisdom on my journey in learning PHP. >> >> Tim >> >> >> Thanks again guys, >> Tim >> >> >> >> I think the comment about your "cannot insert query" was because it >> really did not make sense. Once truly cannot "insert a query". Since you >> ask tho, a more approp message might be >> "Insert query failed to execute.<br>Error returned was " . mysqli_error() >> . "<br>Query was $q" >> >> As for your index issue - you are using an autoincrement(?) field as the >> primary key. Is this related to another record in your db? If not, why >> even have the primary key? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B