hi guys been wondering over this for a little while and cant figure it out. Basically Im including the file below, where I use a query to extract some data. This file is included in another file and the results returned. This works fine however Im having trouble returning the results and getting a field in this file below.

I can return the results and then get the results in the other file, but not in the same one. So:

PHP Code:

$query111 = "SELECT * FROM places WHERE place_id = 5559";    

$result111 = mysql_query($query111)
or die ("The system doesn't like your login details- please try again 
with different ones.");

$row111 = mysql_fetch_assoc($result111);
    
return $row111;
$place_id2 = $row111['place_id']; 


So I cant return row111 and get something from it. Any ideas?

What could cause a problem is your return statement.
If this is placed in a function, anything placed after a "return" statement will be left over, as the function exits at the same time it returns something.

If you are not in a function though, I don't see the point of having a return statement...
Could you explain a bit why it's positioned here, and if it's in a function ?

I'm not sure, but if it's in a if or case statement, it could cause the php engine to break out of the condition too, but that's purely a proposition.
I'm not even remotely sure of that.

tripy,
it's quite a nice point of php. You may return from included file as well as from function. I learned about it not too long ago and sometimes it could be rather useful.

bigbob,
you have an unconditional return from file. It means that exactly this file is not being executed after the "return ..." line. You should rewrite this code in the form of function or whatever.