"drive view" <drivev...@gmail.com> wrote in message news:cam4sn2ip7yncw2-2soq-vjk8suer7u5x96fvpeqoitkkcaj...@mail.gmail.com... > Hi, > > I'm a novice to MySQL and am currently facing the following difficulty. > I'm trying to update a table with a row of data the primary key of which > is > an ID which I believe is an auto incrementing serial number. My first > question is how to check if this is the case. >
If you are updating a row, you should already know the id of the record, so in your update statement you reference it in the where clause. (ie, "where rec_id = $curr_rec_key") > Secondly while trying to insert such a row leaving out this column mySql > is > inserting the row at ID 0 (the previous ID's in the table are from 1 to > 9), > but then will not take further inserts. > > Thanks for any help available. > > > Regards > > Toni > I don't know what the problem here is. Personally I never use auto-inc fields. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
