[PHP] Page display of query resuts using ODBC

[Luc Roettgers]

Hi,

Just wondering if anybody knows a script to display a resultset over several pages 
using page numers  previous, next links.

So far I've only found such scripts for mysql using the the following sql syntax which 
is not odbc compliant: SELECT * from table LIMIT 0, 4

I've looked at many sites to find such a script without luck so far...

Thanks in advance for your help,

-Luc

[PHP] Using odbc_pconnect function

[Luc Roettgers]

Hi,

Trying to use persistant connections to reduce general access times on my tables, I 
have the following problem. When creating my connection with: 

$connectionstring = odbc_pconnect(prov,username,pass); 

I'm able to use it on the current page but how do I resuse the variable 
$connectionstring on other pages since I make calls like:

$queryexe = odbc_do($connectionstring, $query);

Hope this is not confusing. Also, can I make the persistant connection expire after 
there have been no calls to the DB for a certain time?

Many Thanks,

-Luc

[PHP] Can't recover data in php posted with a form tag.

[Luc Roettgers]

I have 2 files runQuery.php and doSQL.php, where the first one is posting data entered 
by the user to the second page and displaying it but the data never arrives. Any idea 
why this would not work, maybe some configuration issue?? Any help is really 
appreciated...


!--  

!-- runQuery.php --
DIV align=left
   FORM name=sql method=post action=doSQL.php
INPUT type=text name=clSQL size=50BRBR
INPUT type=submit name=submit value=Lancer requètenbsp;nbsp;
INPUT type=reset name=reset value=EffacerBR
   /FORM
   I class=normali.e. select * from scpsft/I
/DIV 


!-- doSQL.php --
HTML
BODY bgcolor=#efefde
H1Résultat de la requète:/H1
?PHP
echo ($clSQL);
?
/BODY
/HTML

--