从MYSQL查询不在PHP中输出

Question

my code

$query = "SELECT `url` FROM `$drop` WHERE `vidname`= '$tier_two'";
$dave= mysql_query($query) or die(mysql_error());
    echo "<p>";
print $query;

im trying to the url feild to echo but im coming up with blanks

Answer 1

You can try this:

$query = mysql_query("SELECT url FROM '$drop' WHERE vidname= '$tier_two'");  

while($row = mysql_fetch_array($query)){    

  $url = $row["url"];   
  echo $url;

}