How to return my results (query)?

[evo4ever]

Hey. Im here asking how to return my mysql query as a result! Heres my code:

$dbhost = "localhost";
  $dbuser = "user";
  $dbpassword = "pass";
  $db = "database";

  mysql_connect($dbhost, dbuser, dbpassword);
  if(!$mysql) {
      $error = "Cannot connect to database";
	  return($error);
  }

  $mysqldb = mysql_select_db($db);
  if(!$mysqldb) {
      $error = "Cannot open database";
	  return($error);

  }

  $myquery = "SELECT * FROM hostee_info";
  $result = mysql_query($myquery);
  if (!$result) {
       $error = "Cannot run query";
	   return($error);

  }

How do I echo the results or selected query into the page? Thx.

[cgraz]

<?

  $dbuser = "user";
  $dbpassword = "pass";
  $db = "database";

// Connect to MySQL Server
@mysql_connect($dbhost, $dbuser, $dbpassword) or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db($db) or DIE("Couldn't Select Database");

// Run Query
$query = mysql_query("SELECT * FROM hostee_info");

// Put the results into an array
$a_row = mysql_fetch_array($query);

/* Now display them however you wish. Lets say in your database, you had 3 fields called name, 
email, and phone. Since you put everything in an array, you can just call it up like this */

print "Name: " . $a_row["name"] . "<br>\n";
print "Email: " . $a_row["email"] . "<br>\n";
print "Phone: " . $a_row["phone"] . "<br>\n";


?>

or if you wanted to use tables to organize the results, you could use a while loop. . .

<?

  $dbuser = "user";
  $dbpassword = "pass";
  $db = "database";

// Connect to MySQL Server
@mysql_connect($dbhost, $dbuser, $dbpassword) or DIE("Couldn't Connect to MySQL Database");

// Select Database
@mysql_select_db($db) or DIE("Couldn't Select Database");

// Run Query
$query = mysql_query("SELECT * FROM hostee_info");

// Put the results into an array
$a_row = mysql_fetch_array($query);


// output results

print "<table width=400 cellpadding=0 cellspacing=0 border=0>\n";

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

print "<tr><td width=100>Name: </td>\n";
print "<td width=300> " . $a_row["name"] . "</td></tr>\n";

print "<tr><td width=100>Email: </td>\n";
print "<td width=300> " . $a_row["email"] . "</td></tr>\n";

print "<tr><td width=100>Phone: </td>\n";
print "<td width=300> " . $a_row["phone"] . "</td></tr>\n";

// end your while statement
}

?>

</table>

Hope this helps.