SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2006
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up please help me to solve this problem

    hi all,

    i have around 50 (a-z)records from database.

    i want to display first 2 records each and every letters.

    i can use like operator. but i need a single query
    so please help me.

    my expected output is

    Acura
    Audi
    BMW
    Buick
    Cadillac
    Dhrysler
    Dodge
    Ferrari
    Ford

    Thank U.

  2. #2
    SitePoint Zealot sajjad's Avatar
    Join Date
    May 2005
    Posts
    174
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i think it's a database question not php

  3. #3
    Non-Member Ihtesham's Avatar
    Join Date
    Aug 2006
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Paste the schema.

    There could be several solutions depending on how that data is stored.

    And the forum Databases would be the best place to seek help.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •