Undefined index error

Asked Oct 11 '15 at 04:16

Active Oct 11 '15 at 05:34

Viewed 113 times

This undefined index error pops every time:

Notice: Undefined index: vehicle_id in
C:\xampp\htdocs\TaxiLocator\php\retrive.php on line 39

Notice: Undefined index: model in
C:\xampp\htdocs\TaxiLocator\php\retrive.php on line 42

But only two of the variables are unidentified; the other two variables are displayed on the table.

Is there something wrong with my MySQL db?

php code

<?php
while($vehicle_table=mysql_fetch_assoc($records)){
    echo "<tr>";
    echo "<td>".$vehicle_table['vehicle_id']."</td>";
    echo "<td>".$vehicle_table['latitude']."</td>";
    echo "<td>".$vehicle_table['longtitude']."</td>";
    echo "<td>".$vehicle_table['model']."</td>";
    echo "</tr>";
}
?>

vehicle_id is declared as an int type, while latitude, longitude, and vehicle_id are declared as double, and model is declared as varchar.

Can anyone help?

edited Oct 11 '15 at 05:34

Drenmi

8,492
4
42
51

asked Oct 11 '15 at 04:16

nadun

Could you please add a little more code? How are you populating `$records`, for example? – andrewsi Oct 11 '15 at 04:24
Possible duplicate of [PHP: "Notice: Undefined variable" and "Notice: Undefined index"](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) – sevenseacat Oct 11 '15 at 05:36
Give me your sql query string – Nguyen Sy Thanh Son Oct 11 '15 at 05:37
`print_r($vehicle_table)` – aldrin27 Oct 11 '15 at 08:34

Undefined index error

0 Answers0