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?
No, you can't. You either need to pass it back (recommended) or make it
global (not recommended).
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
return $tbl_id;
}
Now I wish to access that variable in another function thus:
function tbl2($name, $entrytitle, $entrytext)
{
$other_id = tbl1($entrytitle, $entrytext);
echo $other_id;
global $conn;
$result =mysql_query("INSERT INTO tbl2(tbl1_id, name, title, text)
VALUES('$tbl1_id', '$name', '$entrytitle', '$entrytext' )", $Conn);
}
PS : look up mysql_real_escape_string for when you save your data.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
