How to show specific rows?

  • vinay9599

    (@vinay9599)


    11 years, 9 months ago

    I have a table which has Names on Col 1 their Company and Age on Col 2 and Col 3.

    I want to display the Data from ROW 1 with X’s name, company and age on one page while Data from ROW 2 with Y’s name, company and age on another page.

    Please help.

    https://ww.wp.xz.cn/plugins/abase/

Viewing 3 replies - 1 through 3 (of 3 total)
  • jane-taubman

    (@jane-taubman)

    11 years, 9 months ago

    I think you just use the WHERE Clause eg

    where=”name = ‘Fred'”

    Thread Starter vinay9599

    (@vinay9599)

    11 years, 9 months ago

    @jane Taubman – Thanks for the help. I tried multiple option but was finally successful in displaying the result i desired

    I used the following option to display columns i needed from the query to be displayed on http://ncrcricket.com/sql-test-page/

    [abase sql = “SELECT Mat, Inn,No,Runs,Balls,4s,6s,S/R,Ave, 100,50 FROM wce_table WHERE Name = ‘Sanjeev’ LIMIT 0 , 30″]

    The only thing that is missing now is aligning the columns as they do not show in sync with the header

    NSRS

    (@nsrs)

    11 years, 2 months ago

    Above query helped me a lot for single record selection!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘How to show specific rows?’ is closed to new replies.