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

Groups > comp.lang.php > #15168

Re: Problem creating a series of tables

Show all headers | View raw

On 3/31/2015 9:07 PM, Richard Yates wrote:
> On Tue, 31 Mar 2015 16:19:06 -0400, Jerry Stuckle
> <jstucklex@attglobal.net> wrote:
> 
>> On 3/31/2015 3:40 PM, Denis McMahon wrote:
>>> On Tue, 31 Mar 2015 12:14:07 -0400, richard wrote:
>>>
>>>> I am attempting to print a table from the database.
>>>> First row is the year.
>>>> Then each table row lists the information according to rank number.
>>>
>>> It seems you've changed your database layout, as you used to be operating 
>>> on one table per year - in which case there would be no need to include 
>>> the statement "first row is the year"[1] as sensible table names would 
>>> identify the year even in richardian databases.
>>>
>>> But - how do you know "first row is the year"[1]? Are you performing a 
>>> sort operation in the mysql query that orders the data?
>>>
>>> Remember that if you don't specify a sort order in the mysql query, the 
>>> ordering of the records it returns is random.
>>>
>>> [1] Do you mean record when you say row? databases have records and 
>>> fields, not rows and columns, the latter are features of spreadsheets.
>>>
>>
>> Denis,
>>
>> Actually, I've always heard the terms "rows" and "columns", ever since
>> my first introduction to SQL databases around 30 years ago.  Even the
>> documentation talks about table rows and columns, not records and fields.
> 
> 
> And that is the terminology used in phpMyAdmin for setting up mysql
> tables.
> 
> When I was first teaching myself about this it caused me great
> difficulty at first since in the 'Structure' tab the 'columns' are
> laid out as rows in the display. If you 'add a column' to the table it
> adds a row. Then in the 'Browse' tab the columns  become columns. Very
> confusing for a beginner. 
> 

Yes, I can see where that can be confusing.  But remember that
PhpMyAdmin is not the database - it is only a front end to the database.
 The page you're talking about shows the structure of the database,
which is more appropriate to the data being displayed.

If, OTOH, you make a SQL query so you see the data (instead of the
structure), you get the rows and columns.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

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

Thread

Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 12:14 -0400
  Re: Problem creating a series of tables Paul Herber <paul@pherber.com> - 2015-03-31 19:09 +0100
    Re: Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 14:30 -0400
  Re: Problem creating a series of tables Denis McMahon <denismfmcmahon@gmail.com> - 2015-03-31 19:40 +0000
    Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 16:19 -0400
      Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-03-31 18:07 -0700
        Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 21:23 -0400
      Re: Problem creating a series of tables Erwin Moller <erwinmollerusenet@xs4all.nl> - 2015-04-01 12:19 +0200
        Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 15:23 +0200
          Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 10:17 -0400
    Re: Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 20:14 -0400
      Re: Problem creating a series of tables Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-01 02:44 +0000
        Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 23:06 -0400
          Re: Problem creating a series of tables richard <noreply@example.com> - 2015-04-01 00:09 -0400
            Re: Problem creating a series of tables Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-01 20:37 +0000
              Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-01 17:08 -0400
    Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 14:50 +0200
      Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 10:20 -0400
        Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 22:32 +0200
          Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 00:44 +0200
            Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 19:22 -0400
            Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 19:24 -0400
            Re: Problem creating a series of tables "Christoph M. Becker" <cmbecker69@arcor.de> - 2015-04-03 01:46 +0200
              Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 20:45 +0200
          Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-04-02 15:59 -0700
            Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 01:10 +0200
              Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-04-02 18:44 -0700

csiph-web