Posted by Sheldon Glickler on 02/23/06 04:02

"Norman Peelman" <npeelman@cfl.rr.com> wrote in message
news:%G7Lf.10537$_c.569@tornado.tampabay.rr.com...
> "Sheldon Glickler" <sheldonlg@bellsouth.net> wrote in message
> news:sA5Lf.2064$u%.579@bignews1.bellsouth.net...
>> I have a script, testsql.php that I run and it works well.
>>
>> Here are the guts:
>>
>> session_start();
>> require_once("sqlLoginDB.php");
>> mssql_select_db($database_apbLogin, $apbLogin);
>> $_SESSION['curSpeaker'] = '1000129';
>> query = "SELECT * FROM speakers WHERE iOldSpeakerId='" .
>> $_SESSION['curSpeaker'] . "'";
>> $result = mssql_query($query, $apbLogin);// or die(mssql_error());
>> echo "Result: " . $result;
>>
>> It gives me a resource ID number.
>>
>> When I call a function from another function from the a main page, and
> this
>> script is cut and pasted in, the result comes up empty.
>>
>> I am at a total loss here.
>>
>> Shelly
>>
>>
>
> It's giving you a resource id because that's all your asking it for...
> you
> also need something like:
>

No, I have the more following this bit where I do an mssql_fetch_assoc on
the result. I just posted to the point of where the problem was.

Shelly

[Back to original message]