From: | "Andy Arledge" <mrgburg(at)worldnet(dot)att(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | pg_exec : problem |
Date: | 2001-01-23 01:29:05 |
Message-ID: | NDBBJNOEGLGKLPGMIGKPCEAFCCAA.mrgburg@worldnet.att.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
can someone please give me an idea why the 3rd pg_exec won't retrieve the
info from the table.
$link, $t, $userzip, $foundzip - are all global variables, the 1st two
pg_exec's work great.
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 username='$to';")))
{
DisplayErrMsg(sprintf("Error in executing line %s stmt", $selectStmt));
//exit();
}
// get users zip;
if(!($result2= pg_exec($link, "SELECT * from signup where
username='$uname';"))){
DisplayErrMsg(sprintf("Error in executing line %s stmt",
$selectStmt));
//exit();
}
$t = @pg_fetch_object($result2, 0);
$userzip = $t->zipcode;
// get results zip;
if(!($result3= pg_exec($link, "SELECT * from signup where
username='$to';"))){
DisplayErrMsg(sprintf("Error in executing line %s stmt",
$selectStmt));
//exit();
}
$t = @pg_fetch_object($result3, 0);
$foundzip = $t->zipcode;
Attachment | Content-Type | Size |
---|---|---|
winmail.dat | application/ms-tnef | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Leandro Fanzone | 2001-01-23 13:50:17 | Data directory destroyed |
Previous Message | Tom Lane | 2001-01-22 22:00:56 | Re: Inserting TEXT with multiple lines |