[RESOLVED] SELECT Question

[Dumbo]

Everyone on this forum was so wonderfully helpful last week that I figured you guys could help me out again. I've inserted some information into my table "companies" and am trying to get my web browser to display it. Specifically, I'm trying to get "co_name" where the owner is "Frank." The only error message I get is the final one -- "Failed to query" -- but I'm so new that I'm having a hard time figuring out what I've done wrong. Thanks.

 $connect = mysql_connect(host, username, password);
       if(!$connect) {print "Failed to connect";}
 $select = mysql_select_db(database);
       if(!$select) {print "Failed to select database";}
 $info = 'SELECT co_name FROM companies WHERE owner = Frank';
 $result = mysql_query($info);
       if(!$result) {print "Failed to query"; die;}
 print "$result";

[esukf]

You need surround the Frank string with single quotes

//$info = 'SELECT co_name FROM companies WHERE owner = Frank'; 
//should be
$info = "SELECT co_name FROM companies WHERE owner = 'Frank'";

[Dumbo]

Ahh, thank you.