How do I access a local variable?
| From: | abdulazeez alugo | Date: | Sun, 19 Apr 2009 23:54:27 +0000 |
| Subject: | How do I access a local variable? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-291667@lists.php.net to get a copy of this message | ||
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?
Thanks in advance.
Alugo Abdulazeez
www.frangeovic.com
_________________________________________________________________
More than messages–check out the rest of the Windows Live™.
http://www.microsoft.com/windows/windowslive/