Menu
Community /Pin to ProfileBookmark
@NogDogMay 19.2009 — #Do not confuse "record number" with the value in an integer field which is being used as the primary key for that table. You could conceivably delete the first 5 records from that table, such that the lowest-numbered key field would now be have a "6" as its value. If you then did a [b]SELECT * FROM that_table ORDER BY primary_key_column[/b], the first row returned in the result set (which PHP would consider row 0), would have an ID value of 6.
On top of all of that, the sequence in which the records are stored by the database on disk is not necessarily going to be the same as the sequence of that key field. So my best advice is to simply stop thinking of the database records (rows) being in any specific order unless and until you specifically order them via an ORDER BY or GROUP BY clause in your query; and divorce that sequence in your mind from the arbitrary number of [i]result set[/i] rows returned by any query. (For instance, [b]SELECT * FROM table WHERE color='blue' ORDER BY id[/b] might return rows with ID number 5,7,8,9,12,15, and 18, but the [i]result set row numbers[/i] would be 0-6.)@NogDogMay 19.2009 — #Another advantage of mysql_fetch_assoc() is that it's not affected if you change the order of the columns being selected in your query or if you do a "SELECT *" and the database table's column sequence is altered in any way. Also, it makes it easier when reading the code to immediately see which column you are working with at any particular point, e.g. with [b]$row['color'][/b] you know right away what the variable represents, whereas [b]$row[1][/b] or [b]mysql_result($ix, 1)[/b] is not obvious.
Why does MySQL database start at zero but give the first record an ID of 1?
I’m just starting to learn about how to use MySQL database. I insert data using the code that is listed below. It puts the first record in as record 0, but when I look at it, it says it has and ID# of 1. I have it set to autoincrement.
What am I missing?
Here is my code to insert it:
[code=php]
<?php
// Inserts question into drmarie_questions MySQL database
$ownername=$_POST[‘ownername’];
$petname=$_POST[‘petname’];
$species=$_POST[‘species’];
$breed=$_POST[‘breed’];
$age=$_POST[‘age’];
$email=$_POST[’email’];
$question=$_POST[‘question’];
mysql_connect(“localhost”, “deleted”, “deleted”) or die(mysql_error());
mysql_select_db(“drmarie_questions”) or die(mysql_error());
mysql_query(“INSERT INTO question_table (ownername,petname,species,breed,age,email,question)
VALUES (‘$ownername’,’$petname’,’$species’,’$breed’,’$age’,’$email’,’$question’)”) or die(mysql_error());
mysql_close();
?>
If anyone can point me in the right direction I would be very appreciative!
Thanks!
Marie
Sign in
to post a comment11 Comments(s) ↴
0
@NogDogMay 19.2009 — #Do not confuse "record number" with the value in an integer field which is being used as the primary key for that table. You could conceivably delete the first 5 records from that table, such that the lowest-numbered key field would now be have a "6" as its value. If you then did a [b]SELECT * FROM that_table ORDER BY primary_key_column[/b], the first row returned in the result set (which PHP would consider row 0), would have an ID value of 6.On top of all of that, the sequence in which the records are stored by the database on disk is not necessarily going to be the same as the sequence of that key field. So my best advice is to simply stop thinking of the database records (rows) being in any specific order unless and until you specifically order them via an ORDER BY or GROUP BY clause in your query; and divorce that sequence in your mind from the arbitrary number of [i]result set[/i] rows returned by any query. (For instance, [b]SELECT * FROM table WHERE color='blue' ORDER BY id[/b] might return rows with ID number 5,7,8,9,12,15, and 18, but the [i]result set row numbers[/i] would be 0-6.)
0
@NogDogMay 19.2009 — #Another advantage of mysql_fetch_assoc() is that it's not affected if you change the order of the columns being selected in your query or if you do a "SELECT *" and the database table's column sequence is altered in any way. Also, it makes it easier when reading the code to immediately see which column you are working with at any particular point, e.g. with [b]$row['color'][/b] you know right away what the variable represents, whereas [b]$row[1][/b] or [b]mysql_result($ix, 1)[/b] is not obvious.