help

["Andy Arledge" <mrgburg(at)worldnet(dot)att(dot)net>]

i have $uname and $username defined as global variables. in the select
statement where gender='$gender' everything works fine. but immediately
afterward i call pg_exec again and aparently i lose $uname. $uname is the
same as $username and both are null, but at the beginning both are
intialized and contain the correct variable. 

printf(zcode2) returns - zcode2 : Resource id #4. which i can't find
anywhere.
working straight from a command prompt select works fine when i give it a
name to lookup. 

any help would be most appreciated. thanks in advance,

andy arledge

$link = pg_connect("host=localhost dbname=nsingles user=purcell");
        if(!($link)){
                DisplayErrMsg(sprintf("Error connecting to host %s, by user
%s", $hostname, $username));
                exit();
                }

if(!($result= pg_exec($link, "SELECT * from info1 where
gender='$gender';")))
{
	DisplayErrMsg(sprintf("Error in executing line %s stmt",
$selectStmt));
	//exit();
	}
if(!($zcode2= pg_exec($link, "SELECT * from signup where
username='$uname';")))
{
	DisplayErrMsg(sprintf("Error in executing line %s stmt",
$selectStmt));
	exit();
}
$row2 = @pg_fetch_object($zcode2);
$zipcode2 = $row2->zipcode; 
printf("<HR>zipcode  : zipcode");
printf("<HR>zipcode2 : $zipcode2");
printf("<HR>zcode2   : $zcode2");
printf("<HR>uname    : $uname");
printf("<HR>username : $username");.

<<attachment: winmail.dat>>