Posted by Norman Peelman on 02/23/06 02:52

"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:

if ($result)
{
while ($my_resource_data = mssql_fetch_array($result,MSSQL_ASSOC))
{
$my_data[] = $my_resource_data;
}
}

.... you can replace the code located inside the while{} to anything you
like. My code simply dumps the entire result set into an associative array


Norm

[Back to original message]