Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #15205

Re: fetching all items at once - how do you code to display them?

Show all headers | View raw

On Sat, 04 Apr 2015 19:32:29 -0400, richard wrote:

> On Sat, 4 Apr 2015 23:28:57 +0000 (UTC), Denis McMahon wrote:
> 
>> On Fri, 03 Apr 2015 21:54:12 -0400, richard wrote:
>> 
>>> "SELECT * from sixty where (
>>>   (peak='1')
>>>   AND  (year>1959)
>>>   AND  (year<1970)
>>> ) ORDER BY year, sid "
>>> 
>>> Considering this code provided by Erwin Moller, how does one now
>>> display the information?
>>> 
>>> The standard method of using $row=$result() winds up with only the
>>> first item ending up in a displayed table while the other items are
>>> just bunched up together one after the other.
>>> 
>>> If I simply fetch one item at a time, the table is displayed as
>>> wanted.
>>> 
>>> By this usage of the word "table" I am not speaking of the database
>>> table stored on the server. But the html displayed table on the page.
>> 
>> Note that the following is an example that assumes the reader has some
>> competencies and understanding of php, and the use of the ellipsis
>> 
>> <?php
>> 
>> // Start the table:
>> 
>> echo "<table>\n";
>> 
>> // print the table header row
>> 
>> echo "<tr> <th>header</th>... </tr>\n";
>> 
>> // use a loop that fetches every row from the mysqli result // this
>> example assumes the mysqli result is in $result // $data is a local
>> variable in the loop
>> 
>> while ($data = mysqli_fetch_assoc($result)) {
>> 
>> // in here you write out a single table row for each set of // $data
>> from the query result
>> 
>> echo "<tr> <td>{$data['fieldname']}</td>... </tr>\n";
>> 
>> }
>> 
>> // close the table
>> 
>> echo "</table>";
>> 
>> ?>
> 
> Done that.
> What I get is 11 duplicates of the first item.
> So why does it stop at 11 when I have 200 records?

Perhaps your query is not fetching the data you think it is. Without 
running your query against your datatable at the mysql command line, it's 
hard to tell.

I suspect but I can't be sure that the reason you're getting 11 values 
might be linked to the "(year>1959) AND (year<1970)" part of the query.

There might be an issue if you have stored years as strings and are now 
trying to compare those strings with a numeric value. I'm not sure, 
because I don't usually try to compare strings with numbers in mysql.

-- 
Denis McMahon, denismfmcmahon@gmail.com

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-03 21:54 -0400
  Re: fetching all items at once - how do you code to display them? Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-03 22:14 -0400
  Re: fetching all items at once - how do you code to display them? Denis McMahon <denismfmcmahon@gmail.com> - 2015-04-04 23:28 +0000
    Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-04 19:32 -0400
      Re: fetching all items at once - how do you code to display them? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-05 01:15 +0000
        Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-05 10:56 -0400
          Re: fetching all items at once - how do you code to display them? Richard Yates <richard@yatesguitar.com> - 2015-04-05 08:14 -0700
            Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-05 11:24 -0400
          Re: fetching all items at once - how do you code to display them? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2015-04-05 11:18 -0400
            Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-05 11:28 -0400
              Re: fetching all items at once - how do you code to display them? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2015-04-05 11:52 -0400
                Re: fetching all items at once - how do you code to display them? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-06 02:01 +0000
                Re: fetching all items at once - how do you code to display them? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2015-04-08 20:16 -0400
                Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-09 22:32 -0400
                Re: fetching all items at once - how do you code to display them? Richard Heathfield <rjh@cpax.org.uk> - 2015-04-10 07:48 +0100
                Re: fetching all items at once - how do you code to display them? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-11 03:11 +0000
            Re: fetching all items at once - how do you code to display them? Denis McMahon <denismfmcmahon@gmail.com> - 2015-04-06 07:58 +0000
          Re: fetching all items at once - how do you code to display them? Denis McMahon <denismfmcmahon@gmail.com> - 2015-04-06 07:48 +0000
      Re: fetching all items at once - how do you code to display them? Denis McMahon <denismfmcmahon@gmail.com> - 2015-04-05 04:47 +0000
        Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-05 10:58 -0400
          Re: fetching all items at once - how do you code to display them? Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-05 11:21 -0400
            Re: fetching all items at once - how do you code to display them? richard <noreply@example.com> - 2015-04-05 11:40 -0400
              Re: fetching all items at once - how do you code to display them? Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-05 14:55 -0400
              Re: fetching all items at once - how do you code to display them? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-06 02:07 +0000
          Re: fetching all items at once - how do you code to display them? Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-06 02:05 +0000

csiph-web