"Michael Lewis" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I posted this on the PHP-DB list and then realized it was a more general
> question about PHP than DB so I am posting it here also hoping someone can
> help.
>
> I have a fairly common problem that I have not been able to find the
> solution for in the documentation and FAQs. I have to access a MSSQL box
> from a LAMP box using PHP. That part works fine (thank you freetds.org). I
> need to display results from user queries 10 at a time with the basic NEXT
> and BACK logic. I can use the mssql_data_seek function to move amongst the
> record set. The problem is how do I save the results variable between web
> page updates? I cannot save the record set variable in my session because
it
> always returns as zero. Consider the following code:
>
> <?php
> session_start();
> include("localsettings.php");
> $s = mssql_connect($Server, $User, $Pass) or die("Couldn't connect to SQL
> Server on $Server");
> mssql_select_db($SDB, $s) or die("Couldn't open database $SDB");
> $sql="select * from products where prod_id='95038'";
> $ress=mssql_query($sql) or die(mssql_get_last_message());
> $_SESSION['ress']=$ress;
> print $ress."\n";
> $ress=$_SESSION['ress'];
> print $ress."\n";
> ?>
>
> The first time I print RESS is comes back as RESOURCE OBJECT #12, the
second
> time as 0. When I look in the session file, it is zero.
>
> Help!
>
> How can I pass this variable and its contents so they are usable to the
next
> web page?
>
> Thanks in advance.
>
> Michael


Although still in beta phase, you might want to have a look at what SRM
could do for you. www.vl-srm.net

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to