Why don't you ask the question on a SQL Server list? This isn't a put down,
or an attempt to shove you away, but if you can do this in MSFT's
TRANSACT-SQL you will be offloading the work to the database engine which
is designed to do it.
Alternately, can you use two queries, the first which uses TOP, and a
second which also uses top and fetches greater than previous result. That
would also have the advantage of returning small data sets, faster.
Regards - Miles Thompson
At 03:24 PM 1/12/2002 -0400, Joe Van Meer wrote:
Hi there, I have a small php/data driven website and would like to
incorporate record paing. Unfortunately I'm working with sql Server
temporarily, but I'm still required to do this. So since I wasn't allowed to
use the handy LIMIT in my sql statement I figured I'd dump my results into a
mulitdiensional array and navigate through the records that way. I know this
propbabbly isn't the best method, but it's the way I have to do it for now.
I've managed to display my records out of the array, but would now like to
incorporate a next' and a 'previous' button to navigate through the array.
Can someone take a look at my code below and tell me how I'm to go about
doing this? I thought maybe by having 2 functions that would advance my
array pointer and another to retreat the pointer would do the trick. I'm
unsure how to incorporate it. I've added two functions within the
below, not sure if they are appropriate or not though.
Thx Joe :)
Code:
if(!isset($consultantarray)){
//connect to db
$connectionToDB = odbc_connect(cdxcffcoltant, jo7gecon, josje7con);
//create query statement
$sqls = SELECT consultantid, firstname, lastname, city, stateprovince,
country, category, yearsexp FROM CONSULTANT WHERE category ='$category'
ORDER BY yearsexp DESC ;
//execute the sql statement (query) on the connection made
$resultset = odbc_do($connectionToDB, $sqls);
//initialize the consultant arrays
$consultantdetailsarray[] = array();
$consultantarray[] = array();
//initialize a variable to zero for start of array below in while loop
$x = 0;
// while there is still results fetch the data from the database --- while
loop
while(odbc_fetch_row($resultset)){
$consultantdetailsarray[0] = odbc_result($resultset, 1);
$consultantdetailsarray[1] = odbc_result($resultset, 2);
$consultantdetailsarray[2] = odbc_result($resultset, 3);
$consultantdetailsarray[3] = odbc_result($resultset, 4);
$consultantdetailsarray[4] = odbc_result($resultset, 5);
$consultantdetailsarray[5] = odbc_result($resultset, 6);
$consultantdetailsarray[6] = odbc_result($resultset, 7);
$consultantdetailsarray[7] = odbc_result($resultset, 8);
//dump each consultant into the new array called $consultantarray
$consultantarray[$x] = $consultantdetailsarray;
//increment to next element of array
$x++;
}
}
*
function nextFive($array, $number){
for ($counter = 0; $counter $number; $counter++){
next($array);
}
}
function previousFive($array, $number){
for ($counter = 0; $counter $number; $counter++){
prev($array);
}
}
*
//loop through the elements of retrieved array (2nd one holding the
consultant details)
//second loop to grab through $consultant details array elements
foreach($consultantarray as $y){
list($cid, $firstname, $lastname, $city, $stateprovince, $country,
$category, $yearsexp) = $y;
print trtd align=leftfont color='#663399' face='verdana' size=2a
href='consultantdetails.php?cid= . $cid . ' . $firstname . .
$lastname . /a/font/tdtd align=leftfont color='#663399'
face='verdana' size=2 . $city . /font/tdtd align=leftfont
color='#663399' face='verdana' size=2 . $stateprovince . /font/tdtd
align=leftfont color='#663399' face='verdana' size=2 . $country .
/font/tdtd align=leftfont color='#663399' face='verdana' size=2 .
$category . /font/tdtd align=leftfont color='#663399' face='verdana'
size=2 . $yearsexp . /font/td/tr;
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
