Undefined Offset

[delusion7]

I am getting this error "Undefined offset: 9 in C:\Course Technology\1687-5\Chapter.10\UpdateContactInfo.php on line 36"
this is the code I am recieving the error on:
[PHP]if (mysqli_num_rows($QueryResult) > 0) {
$Row = mysqli_fetch_row($QueryResult);
$First = stripslashes($Row[3]);
$Last = stripslashes($Row[4]);
$Phone = stripslashes($Row[5]);
$Address = stripslashes($Row[6]);
$City = stripslashes($Row[7]);
$State = stripslashes($Row[8]);
$Zip = stripslashes($Row[9]);
mysqli_free_result($QueryResult);
[/PHP]
My array has 9 elements, everytime I change the indexes listed above to 1 less, assuming zero-based array, the data that is in $First name is displayed in the $Last name field. Please help!!
Thanks

[ronverdonk]

When your $row has 9 elements, the first one is $Row[0] and the last one is $Row[8], so $Row[9] is outside the range.

Ronald :cool:

[acoder]

My array has 9 elements, everytime I change the indexes listed above to 1 less, assuming zero-based array, the data that is in $First name is displayed in the $Last name field. Please help!!
Thanks

Check your database and SQL if that is the case. Your array is zero-based. row[3] will be the fourth field.

[ronverdonk]

I suppose you did a SELECT * in your query. Who gave you the quarantee that the sequence of the columns in your table would be identical to the order you created them in? If you want them in a specific order, issue a SELECT col1, col2, .... etc. Same applies to row sequence.

It usually is so, but MySQL gives no guarantee at all, they even deny it, that it is. Remember, the whole point of a relational setup is to decouple data storage and presentation.

See also this post about that same subject.

Ronald :cool: