Help: A newbie problem here with the undefined index:

[enhu]

Notice: Undefined index: positon in C:\wamp\www\enhu\content.php on line 15

About Enhu

 

 

  $result = mysql_query("SELECT * FROM subjects", $connection);

                            if (!$result) {

                                die("Database query failed: " . mysql_error());

                            }

                 

                        while ($row = mysql_fetch_array($result)) {

                            echo $row["menu_name"]." ".$row["positon"]."<br />";

                        }

 

 

 

The line 15th line  the while statement:

 

[dropfaith]

.$row["positon"].

 

its sayin this doesnt exist from your db are you sure thats the exact name of the field

[enhu]

 

i'm not really sure how to fix this, does this mean that i have to input it again to the database or should i replace the syntax so it would function?

 

 

[enhu]

 

you were right.  i take the ".$row["positon"] away

and leave the while statement to this

 

hile ($row = mysql_fetch_array($result)) {

                            echo $row["menu_name"]."<br />";

                        }

 

and it works. thank you. you didnt seem to drop my faith at all.

[Maq]

Go to your database with PhpMyAdmin or w/e you use and find out what fields you have in the 'subject' table.  When you SELECT * it means you select everything and if you only need that one row then only select menu_name.  So obviously the position field does not exist.