Mysql select trouble

[cleavela]

I'm using objects to manage my DB interaction. I'm trying to send a select statement to the DB and keep getting an empty result. The DB connection is working and the select function works fine with my sessions (one of my tables stores the id and passwords of users, I check this first thing on entering the page) but even a simple select * from tablename statement for my other table always returns an empty result (I check and there's no error connecting to the database). I can see my sql is good because I output the query to the screen to check what's being submitted. And when I try the query directly in mysql (not through a php page) it works fine. Any ideas on why I'm having this problem?

[mrhappiness]

maybe your code is wrong?

post the query method of your object please

[cleavela]

function select($sql="")
{
print "\nselect $sql\n";
if (empty($sql)) {
print ("empty sql");
return false;
}
if (empty($this->CONN)) {
print ("empty conn");
return false;
}
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if ((!$results) or (empty($results)))
{
print ("empty results");
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}

The above is the function with the debugging print statements I added. I don't beleive it's incorrect since it works fine with the session check (when I don't have the print statements in there, obviously). When I pass it the simple sql statement: "select * from tablename" it prints "empty results".

Here's the function without the debugging prints added:

function select($sql="")
{
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if ((!$results) or (empty($results)))
{
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}

[mrhappiness]

$results = mysql_query($sql,$conn) or die(mysql_error());