problem with function

[chiprivers]

i created a function that queried database for records and then returned results but it is not working!

function returnResult() {

// build query
$query = "blah blah";

// run query
$result = mysql_query($query);

// return result
return $result;

}

Then when I try and use the results like this:

while($row = mysql_fetch_array($result)) {

  // do this

}

it does not work!! is there a rule relating to functions that stops them from returning such information?

[fert]

are you sure it's doing the query?

[chiprivers]

well if I put the

while($row = mysql_fetch_array($result)) {

  // do this

}

bit inside the function instead of returning the results of the query, it works, so the query must be working.

Is there any rule about retuning an array?

[fert]

your function doesn't return an array, it returns a resource, but PHP can return any type of varible

[chiprivers]

I am sure there is nothing wrong with my code, has anybody experienced simillar problem?

[.josh]

..and you are calling your function by doing:

[code=php:0]
$result = returnResult(); // this right here?
while($row = mysql_fetch_array($result)) {

  // do this

}
[/code]

[chiprivers]

I knew it would be something simple! Not doing much work with my own functions I didn't realise that you had to do:

$result = returnResult();

I was just doing:

returnResult;

I have amended script and it is working fine now. Many thanks CV