[Resolved] include not making variables available

mikotondria

Hi..
I am retrieving my sql array like so:

$sql = select etc..
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

then extracting the array like so:
foreach ($row as $key => $value){
$$key = $value;
}

This works fine when I place this in the actual file, but if I try to put the SQL and the foreach into a seperate include, I cannot use any of the variables. :bemused:

I was making the above in to a function, and passing the $customer_id to the '$sql =' bit.

Do I need to, for instance, 'return ($value)' or something ?
Its got me a little confused..

This is for a project where I have about 50 forms that I need to auto-generate and populate RTF versions of, so I thought it would be an ideal candidate for 'include'.

Thanks in advance 🙂

Mike.

laserlight

If you're using the variables in a function, then you would have to return values, pass arguments by reference, and/or declare the variables global in the function.

If not, then there really shouldnt be a problem with using an include file in this way.

mikotondria

Hey, thanks Laserlight..
Im pleased to know it should work.

Next question 🙂..

What would be the syntax for getting all the variables out of this function if I was put it in an include ?
just like - return($$key as $value) or similar ?

And whats the global option ?

Best wishes to Singapore 🙂..
Thanks,
Mike.

laserlight

You might want to read more about functions in the PHP Manual:
http://www.php.net/manual/en/language.functions.php

mikotondria

hi 🙂..

Yeah, got it sorted, thanks 🙂

Appreciate your help.

jayant

cool,

so mikotondria, how about marking the thread as resolved?

mikotondria

yup have just done it..
good spot - thanks for your diligence there 🙂

Always wanted to visit India, BTW - mostly for the food, lol - can't get enough of it over here in the US :/.

Cheers and have a good day.

Mike.

jayant

wow!!!

do meet me if you get a chance to come here.