Problems Returning an Array from a Function

[Anon]

Okay I'm sure this is just a stupid error on my part but I've been trying for the better part of 3 hours to figure it out with no success. I've read everything I can about returning an array and nothing seems to point me in the right direction. Here's the related code:

function setSql($req_sql) {
$this->sql = $req_sql;
}
function getSql() {
return $sql;
}
function setQuery($req_query) {
$query = $req_query;
}
function getQuery() {
return $query;
}
setSql("SELECT * FROM band");

setQuery(mysql_query(getSql()));

The setSql and getSql statements are correct, I know that because before I added the setQuery function I used to just use this:

setSql("SELECT * FROM band");

$result = mysql_query(getSql());

and it worked fine. I think there is a problem with either setQuery or getQuery. The database connection is already made and it works before this code is called. Does anyone have a clue as to what might be causing this to return nothing? When it should be returning 230 values, as it did before I added the setQuery function.

Thank you!
Jared

[Anon]

SetSql and GetSql truly do appear to work fine. But
you don't show us exactly how you were expecting to
<i>use</i> the other functions, so I'm a little unclear
how to advise (other than to say this looks an awful
lot like Stroustrup's pejorative description of an object
as "a bag of bits with get and set functions.")

[Anon]

I'm sorry I thought it was clear, my mistake. Here is a more indepth description of the problem. This code:

setQuery(mysql_query(getSql()));

is where the problem is. setQuery is being sent a point to the mysql_query results, yet for some reason passing it to:

function setQuery($req_query) {
$query = $req_query;

}

Nullifies the query, I don't know if it's getting passed incorrectly or if it just won't work like this. Which I think it should, so I think the problem might be in how I'm passing it to the function. From all my reading and searching I haven't been able to determine the error on my own. Yes I am following the object oriented route, his design is correct. I am going to be modifying it as I go along though, improving and streamlining. First I have to get it working though. Thanks for taking the time to read this.

Jared