I have a simple class:
Code: Select all
class DbQuery{
var $selectWhat;
var $table;
var $where;
var $queryString;
var $row;
function buildQuery($selectWhat, $table, $where)
{
// check if a WHERE statement is needed
if($where){
$this->where = $where;
return $this->where;
}
$this->queryString = "SELECT ".$selectWhat." FROM ".$table;
$return = mysql_query($this->queryString) or die("Could not connect to MySQL database from buildQuery" .mysql_error());
$this->row = mysql_fetch_array($return);
}
}Code: Select all
include('includes/classes/DbQuery.php');
$dbquery = &New DbQuery;
$dbquery->buildQuery("*", "events", false);
foreach ($dbquery->row as $value) {
echo "$value<br />\n";
}link if needed: http://www.beyondblueinteriors.com/v2/specials.php
Thanks
Any help would be great,