简单的代码不工作[关闭]

Question

Hello guys I want to show the database on my website using this code which is given below but it's giving me annoying error again and again. I have tried everything but nothing is working it give me same error notice

Here is the error Notice

Notice: Undefined index: name in C:\xampp\htdocs\test3\index.php on line 15

Here is the PHP Code

<?php
$connect = mysql_connect("localhost","root","123");

if(!$connect) {
    die("Failed to Connect: " . mysql_error());
    }
    if (!mysql_select_db ("login")){
        die("Failed to Select DB: ". mysql_error());
    }

    $results = mysql_query ("Select * from users ");

    while($row = mysql_fetch_array($results)){
        echo $row['name'];
    }
?>

I have also tried to replace mysql_fetch_array($results) with this mysqli_fetch_assoc($result) and it's also not working please run this code yourself and then give me that code. Thanks

Answer 1

You can also simply do it this way to avoid confusion on the if's

mysql_connect("localhost","root","123") or die("Failed to Connect");

mysql_select_db ("login") or die ("cannot connect to db");

$results = mysql_query ("Select * from users ");

while($row = mysql_fetch_assoc($results))

{
 echo $row['name'];
}

Since the error refers to the name, you might want to check your users table if the column name exists.