从php中的mysql表中选择一个字符串不显示输出

Question

I'm trying to extract a string field, under a column called "whenadded", of a mysql table (called "values") with a php script. I'm using this code:

<?php
  include("common.php");
  $link=dbConnect();
  $name = safe($_POST['name']);
  $mysqldate = mysql_query("SELECT `whenadded` FROM `values` WHERE `name`= `$name`");
?>

In this table I have only two columns: name and whenadded. Both are strings. If I try to display the result of $mysqldate, I don't see anything (white field).

---

[SOLVED] At the end I solved using this:

include("common.php");
    $link=dbConnect();
    $name = safe($_POST['name']);

    $query = mysql_query("SELECT * FROM $dbName . `valorigps` WHERE name = '$name'");

    while($row = mysql_fetch_array($query))
    {
        echo  $row['whenadded'];      
    }

Answer 1

your query string shoud be this:

$mysqldate = mysql_query("SELECT whenadded FROM values WHERE name= '$name'");

or

$mysqldate = mysql_query("SELECT whenadded FROM values WHERE name= '{$name}'");

no need of quote for table columns!