Resolved Undefined Index Problem

[hackarchives]

i created an email registration script and when i tried to display all email addresses from it i get an undefined index error.

Code of test.php

PHP Code:

<?php
require("config.php");
 $test = mysql_query("SELECT * FROM Email");
  while($row = mysql_fetch_array($test))
  {
  echo $row['email'];
  echo "<br />";
  }
  mysql_close($con);
?>

Error i get :

[webdev1958]

So the error message can't be more clear. It's telling what the error is and in what line it's in.

What's your question?

Have you confirmed the query actually ran? If yes, then have a look at the column names in the table and I think you'll find a mismatch to what your code is trying to access.

[hackarchives]

Sorry, it was a foolish mistake in database.I corrected it.Thanks for help anywayz

[webdev1958]

glad it's sorted out