Morning peeps,

I was wondering if people could advise of better ways to do what i've attempted to.

Its just a small class to carry out a select query, as i'm learning i guess i need critism for me to learn from my mistakes so fire away. Ignore how i have displayed the data as thats not what im intrested in, that was just to show it worked.
Beleive me, its nothing fancy!

Code PHP:
class select {
  var $query; // will store the query string only.
  var $result; // will store the results after the execute function is called.
  function __construct($columns, $table, $clause){
    // Create the query and store in var "query"
    $query = "SELECT ";
    $query .= implode(", ", $columns); // separate the colums.
    $query .= " FROM ".$table;
    $query .= $clause;
    $this->query = $query;
  function execute (){
    //execute the query and store the results into the var "results";
    $this->result = mysql_query($this->query);

view page:

Code PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>OOP in PHP</title>
<?php include('class_lib.php'); ?>
<?php include('conn.php'); ?>
//setup query parameters
$columns = array("username","email"); // select these columns.
$table = "users";// tables to select from
$clause = " WHERE user_id !='1'"; //class query, options.
$q_get_usrname_email = new select($columns, $table, $clause); // create a new object for select.
$q_get_usrname_email->execute(); // execute the query.
//output the query.
while ($row = mysql_fetch_assoc($q_get_usrname_email->result)){
  echo $row['username']." ".$row['email']."<br>";

Thanks for any pointers in advance.