[RESOLVED] error: Undefined Index !!!help please!!!

dmeghrazi

my friend has been working on this simple code to leave comments on a site for 12 hours now... i hope you guys can help

this is the code:

<?php
$username="root";
$password="";
$database="critic";

$first=$POST['Name'];
$last=$POST['Lastname'];
$comment=$_POST['Comment'];
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
{
$query = "INSERT INTO critic VALUES ('','$first','$last','$comment')";
mysql_query($query);

while($row = mysql_fetch_assoc($result)){
echo "<div class=\"messages\">";

    echo  $row['Name'] ." "; 

    echo  $row['Lastname'] ." "; 

    echo  $row['Comment'] ." "; 



  echo "</div>";

}

mysql_close();

?>

but she says she gets an error for variables like Name, Lastname, Comments
error: Undefined Index

and she says that the names are exactly like in the database.

please help with this, its kinda urgent 😛

thanks in advance 😃

ps. i think she uses drupal and easyPHP, dont know it that info was needed

burfo

Hello,

Please edit your post and put your PHP code inside of [php] [/php] tags.

Looking at the code you've posted, the variable $result is never defined. Executing an INSERT query will not return a resultset. Did you just omit the code which sets the $result variable?

Either way, "undefined index" means there is no 'Name' index inside of the $row array (for example). mysql_fetch_assoc likely isn't returning what you expect. Perhaps you have the column names wrong? Try doing

var_dump($row);

inside the while loop.

Weedpacket

As well as what burfo said, there is another problem:

$first=$_POST['Name'];
$last=$_POST['Lastname'];
$comment=$_POST['Comment'];

If the form hasn't been submitted, or if the form has been submitted and some of the fields listed here haven't been filled in, then their $_POST[...] variables won't exist.

So, check that they exist before you try to use them. This is what [man]isset[/man] is for.

dmeghrazi

thanks alot to the both of you, problem solved

bradgrafelman

Don't forget to mark this thread resolved.