简单的php + mysql从数据库打印变量

Question

sorry to bother you all but I'm really struggling with this one:

I connect to my database fine and then I try the following mysql statements:

$query1 = "select row1 from mydatabase where row2 = $Name ";
$answer1 = mysql_query($query1);

However, a few lines later when I try :

echo $answer1;

I'm given only nulls :(

Can anyone give me any suggestions please?

edit: SQL logins:

mysql_connect("correct", "username", "password");

mysql_select_db("dbname") or die(mysql_error());

Answer 1

everything you did is right you have just to fetch the data like this:

$query1 = "select row1 from mydatabase where row2 = $Name ";
$answer1 = mysql_query($query1);

while($data= mysql_fetch_array($answer1)){
    echo $data['row1'];
}

And this is a complet answer, i adjust it as you need ;)

<?php
    //Connect to your database
    $con=mysqli_connect("db_hostname","db_user","db_password","db_name");

    // Check connection
    if (mysqli_connect_errno())
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    //Value of the row to select
    $row2 = 'some value';

    //Make select query
    $result = mysqli_query($con, "SELECT row1 FROM MyTable WHERE row2='$row2'");

    //Fetch datas
    while($row = mysqli_fetch_array($result))
    {
        echo $row['row1'];
        echo "<br>";
    }

    //Close database
    mysqli_close($con);
?>

Good Luck :)