PHP, MySQL: can't explain this undefined index error

Question

I'm getting an undefined index error with this code:

// Select all bookings
$sql = "SELECT * FROM booking";

$result = mysqli_query($con,$sql);

echo "<p>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    // echo $row['custName'] . " - " . $row['roomNb'] . " - " . $row['date'];
    echo $row['custName'];
}

Error:

Notice: Undefined index: custName in C:\xampp\htdocs\alxbook\index.php on line 40

I'm selecting all columns from my table. I have no problem with $row['roomNb'] and $row['date'] but for some reason $row['custName'] is giving me problems. The spelling of custName is correct.

What could be causing this?

Column does not exists in table, it seems. Show your table's structure. — Alma Do
– Alma Do, Commented Aug 28, 2013 at 12:43

RiggsFolly · Accepted Answer · 2013-08-28 12:43:37Z

2

Put a piece of debug code into your script to proove that the name is correct:-

// Select all bookings
$sql = "SELECT * FROM booking";

$result = mysqli_query($con,$sql);

echo "<p>";

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

    print_r( $row );  // debug code

    // echo $row['custName'] . " - " . $row['roomNb'] . " - " . $row['date'];
    echo $row['custName'];
}

answered Aug 28, 2013 at 12:43

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Juicy Over a year ago

Thank you for this. It appears the column name contained a space at the beginning. Very confusing as the space char does not appear in phpmyadmin! (that is probably a bug no?) So it was a typo from when I created the tables. But by using your debug code the space char does appear. Thank you

RiggsFolly Over a year ago

@user2018084 I would remove the space from the column name rather than put something into php to remove it.

Collectives™ on Stack Overflow

PHP, MySQL: can't explain this undefined index error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related