Re: Only showing 20 lines per page...

With a simple calculation of records per page, total records & requested
pagenumber you'll only have to retrieve the relative resultset from the
database, which will mean less resource use with both database & PHP. Your
mentioning of 'storing the results to an array and looping through that way'
get's me a bit confused. It'd be a waste to turn it into an array, and then
proceed. Why not mysql_fetch_array() the rows and perform your desired
actions immediately?

I thought mysql_fetch_array() did store the results in an array?

Mike

.

Relevant Pages

  • Re: Serializing data vs Storing it in a seperate table
    ... and storing it in a single entry in a table or storing each element of ... Do some research on "database normalization". ... It really depends how big the array is and whether you ...
    (comp.lang.php)
  • Re: Serializing data vs Storing it in a seperate table
    ... and storing it in a single entry in a table or storing each element of ... the array in a separate table and associating the entries with the entry ... Do some research on "database normalization". ...
    (comp.lang.php)
  • Re: Slow Macros in Excel 2007
    ... fetching and storing from a database. ... What does an Array() function have to do with reading/writing a database? ...
    (microsoft.public.excel.programming)
  • About DataType Convert in CF2003
    ... I need Convert a Double Array to a Byte Array for storing it to ... Database. ... Does anyone can give me a useful cue? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: KirbyBase
    ... creating objects from the database records was much easier. ... Hal, I don't know if you have had a chance to take a look at the beta yet, but I basically tried to implement a uniform way to specify one-to-one links, one-to-many links, and calculated fields in the ... I suppose it would in effect be embedding an array where all the ... My first couple of attempts at adding more complexity to KirbyBase did not honor this concept. ...
    (comp.lang.ruby)