On Mon, Apr 20, 2009 at 12:54:27AM +0100, abdulazeez alugo wrote:
>
> Hi guys,
>
> I have a function inside which I set alocal variable to store a result. Can I
> access this variable in another function? if yes then how?
>
> function tbl1($entrytitle, $entrytext)
>
> {
>
> global $conn;
>
> $result= mysql_query("INSERT INTO tbl1(tbl1_id, title, text)
>
> VALUES('NULL', '$entrytitle', '$entrytext')", $conn);
>
> $tbl_id=mysql_insert_id($conn);// this is the local variable I'm setting
> to get the last auto increment id
>
> }
>
>
>
> Now I wish to access that variable in another function thus:
>
> function tbl2($name, $entrytitle, $entrytext)
>
> {
>
> global $conn;
>
> $result =mysql_query("INSERT INTO tbl2(tbl1_id, name, title, text)
>
> VALUES('$tbl1_id', '$name', '$entrytitle',
> '$entrytext' )", $Conn);
>
> }
>
>
>
> Or is there a better way to store the variable?
If a variable is local to a function, there is no way to access that
variable outside that function. You can pass it back as a return value
from the original function, or make it global (not advised) to make it
visible in other functions.
Paul
--
Paul M. Foster
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
