how do i hold the result of a query and take that result and run another query??
=========orginal query=======
/* function userblock() {
global $user, $cookie, $prefix, $dbi;
if((is_user($user)) AND ($cookie[8])) {
$getblock = sql_query("select ublock from $prefix".users." where uid='$cookie[0]'", $dbi);
$title = "".MENUFOR." $cookie[1]";
list($ublock) = sql_fetch_row($getblock, $dbi);
themesidebox($title, $ublock);
}
}*/
========== what i'm working on===========
/* function userblock() {
global $user, $cookie, $prefix, $dbi;
if((is_user($user)) AND ($cookie[8])) {
$getblock = sql_query("select ublock from $prefix".users." where uid='$cookie[0]'", $dbi);
$title = "".MENUFOR." $cookie[1]";
$result = sql_fetch_row($getblock, $dbi);
$query = mysql_query("SELECT code ,P_last FROM ${prefix}_stock_quotes WHERE code ='$row'")
$ublock = $result???????;
*/