Include this into my code..

[adamjblakey]

Hi,

I currently use this for extracting data from my DB.

[PHP]
$new = new database;
$new->selects("SELECT * FROM table");
$result = $new->getRes();
$countrows = $new->countrows();

$smarty->assign('result', $result);
$smarty->assign('countrows', $countrows);
[/PHP]

I have come across this though to extract data but includes pagnation also.

[PHP]
$dataCollection = array();
$getData = mysql_query("SELECT * FROM table");
$countrows = mysql_num_rows($getData);

while ($r=mysql_fetch_array($getData)) {
$tmp = array(
'field1' => $r['field1'],
'field2'=> $r['field2'],
'field3'=> $r['field3'],
'field4'=> $r['field4'],
'field5'=> $r['field5']
);

array_push($dataCollection, $tmp);

}

// Assign the results to an array
$pagination = new pagination();
$dataPages = $pagination->generate($dataCollection, 6);
$smarty->assign('listing', $dataPages);
$smarty->assign('pagination', $pagination->links());
$smarty->assign('countrows', $countrows);
[/PHP]


My question is there any way to include the pagnation section into the first example as i don't like having to list all my fields.

Cheers,
Adam

[rohypnol]

What is "pagnation" are you referring to pagination?
Anyway, there's no point in lines 6-12, you could have easily used array_push($dataCollection, $r) in stead of lines 6-14.

[adamjblakey]

Not exactly what i wanted but works just the same, cheers :)